Introduction For this Workout Wednesday, we are putting a Power BI spin on a Tableau viz created by Luke Stanke and Spencer Bauke for their Workout Wednesday 2023 Week 14. While we could probably match nearly exactly to the original Tableau viz by using Deneb in Power BI, I wanted to see what I could …
2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games Read More
Introduction The April 2023 release of Power BI Desktop gave us dynamic format strings for measures. While the end result could be previously accomplished by using calculation groups, we can now have measures with different formats based upon various conditions – no need to go into Tabular Editor to do this now! While we can …
2023 Week 16 | Power BI: Measure Format Strings and Conditionally Formatted Titles Read More
Introduction This week we are getting a bit artistic and taking inspiration from a visual that was recently published by Robin Rohwer on Twitter. She created a connected scatterplot that uses a flower emoji to represent each point. I thought her visual was wonderful, so I set out to create something like it in Power …
2023 Week 13 | Power BI: Create a connected scatterplot with image markers Read More
Introduction This week we are making a table with microcharts (sparklines). Power BI does offer built-in sparklines, but sometimes we want formatting options not available with the defaults. Our challenge this week uses both the built-in sparklines and custom SVG images in a table. Requirements Create a custom column with the following logic: If the …
2023 Week 09 | Power BI: Create a table with custom and built-in microcharts Read More
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 …
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 …
