Introduction The first snowfall in Denver was unseasonably late this year. So I got curious about the data and decided to make a visualization. While this one does communicate with data, it’s taking a bit of artistic license. This is your challenge as well: create a first snowfall scatterplot with some wintery visual effects. You …
2025 Week 50 | Power BI: First Snowfall Scatterplot Read More »
Introduction I’ve been reading the new book Dashboards That Deliver by Andy Coatgreave, Amanda Makulec, Jeffrey Shaffer, and Steve Wexler. Chapter 14 contains an eCommerce dashboard by Dorian Banutoiu that shows how many people viewed a product, added it to their cart, and then actually purchased it. I appreciated the compact nature of what the book …
2025 Week 41 | Power BI: eCommerce metrics bar-in-bar visualizations Read More »
Introduction Recreating visuals you find online helps you build visual design skills and find workarounds to common problems or feature gaps in Power BI. This week, we are recreating this infographic from Visual Capitalist about the change in global wealth. The original is shown below, followed by my version in Power BI. Requirements Create a …
Introduction This week we are building a nullity matrix, a tabular visual that helps us to easily see which rows and columns have null data. There is a library for this in Python, but you need to “roll your own” in Power BI. I found the Python library and liked the idea of visualizing null …
2025 Week 14 | Power BI: Create a nullity matrix Read More »
Introduction The January 2025 update of Power BI Desktop brought us some enhancements to the tree map visual, including 3 new tiling methods and options for spacing between groups and nodes. So this week we are trying out those features to make a tree map organized into columns. Requirements Download the “Regional Sales Sample.pbix” file …
2025 Week 7 | Power BI: Create a tree map organized into columns Read More »
Introduction There are times where we want to compare categorical data with a total, perhaps an average. And sometimes we don’t want to see that total at the bottom of a table. So this week we are creating a bar chart that contains a “total average” bar. We want the bar chart sorted descending by …
2025 Week 5 | Power BI: Add an All Category to a Bar Chart Read More »
Introduction It’s cold and snowy in many places in the United States this week. So we are making an infographic to remind people about ice safety. It’s important to check that ice can support the weight of your desired outdoor activity, so you won’t fall through or harm the area. Let’s use Power BI to …
2025 Week 2 | Power BI: Ice Thickness Infographic with Core Visuals Read More »
Introduction A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it’s inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look …
2024 Week 49 | Power BI: Visualize Ranges with Percentiles Read More »
Introduction A bump chart shows changes in rank over time. This week, inspired by a visual from Statista Charts, we are making a bump chart of the countries with the highest GDP in 3 selected years. The example below uses a ribbon chart core visual to create the bump chart, but you are welcome to use …
Introduction There are a few ways to visualize movement in Power BI. This week, we are visualizing race cars moving on a track. The example report below uses Deneb, but you could also complete this challenge by combining a custom visual and the Play Axis visual. In the report below, once you click the Go …
2024 Week 41 | Power BI: Visualize a Drag Race with Animation Read More »
