Introduction For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered. Requirements Create a calendar visual: Show day of the week on rows and week on columns. (Hint: If you get stuck on …
2023 Week 06 | Power BI: Create a Calendar Heatmap Read More »
Introduction For our second week of Workout Wednesday 2023 Power BI Edition, we are taking inspiration from a recent Washington Post interactive story titled “See just how bad a year it was for your retirement account — and why”. The article looks at the closing price of the S&P 500, comparing the value at the …
2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations Read More »
Introduction While we looked at SVG measures in a matrix in week 20, we are taking a different approach this week. SVG measures can be used in other visuals, and they can be designed to include links. In the below Power BI report, I’ve got 4 visuals populated by SVG measures. Initially, all 4 visuals show …
2022 Week 48 | Power BI: Conditional SVG Measures Read More »
Introduction We first looked at error bars in week 28. But error bars have several formatting features and can be used in several types of visuals. This week, we are going to use error bars to show a dynamically populated range around an average. Requirements Calculate the average height and standard deviation for the heights. …
2022 Week 39 | Power BI: Use error bars to show statistical ranges Read More »
Introduction This week we are exploring another lesser used chart type: the comet chart. Comet charts show the evolution of one or two measures over time. They allow you to see change between two time periods across a category while emphasizing the direction of the change. You might use a comet chart instead of a dumbbell …
Introduction This week, we are taking a look at a lesser used visualization type called a stream graph. Stream graphs are similar to a stacked area chart, but they have values displaced around a central axis rather than stacking on top of an axis. They have received criticism in the past for being difficult to …
Introduction For this workout, we are visualizing data in a scatterplot in a bit of a non-traditional manner. This week marks 26 years since Ella Fitzgerald, the “Queen of Jazz”, passed away. So we are visualizing melodies to a few of her songs. My approach is a bit abstract – not quite sheet music but …
Introduction For the month of May, we are remaking Tableau visualizations with Power BI. Although the visuals made by the two tools may be similar, the calculations and formatting options are a bit different. This makes some things easier in one tool compared to the other. If you use both Power BI and Tableau, feel …
2022 Week 18 | Power BI: Remake this Tableau budget burndown chart Read More »
Introduction For this last week of March, we are continuing our project management theme. The challenge this week is to use Deneb to build bullet charts using the provided data. Bullet charts were created by Stephen Few to offer an alternative to clunky gauges. Bullet charts are used to compare a featured measure to one or …
2022 Week 13 | Power BI: Build a Bullet Chart with Deneb Read More »
Introduction Welcome to week 7 of Workout Wednesday for Power BI 2022. We are again using the Data Visualization Society‘s annual State of the Industry survey results. This week we are looking at how we can visualize parallel sets. Although this may not be a visual that we use often, it can be very useful for multivariate analysis. …
