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 …
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
Introduction In honor of the Power BI Desktop dark mode being scheduled for public preview this month, we are making a report that allows you to switch between light mode and dark mode. Requirements Get the data from Data.World. Filter the report to the year 2024. Create a card that shows current year sales. Create …
2024 Week 37 | Power BI: Create a Report with Light and Dark Mode Read More
Introduction This week, we are recreating a previous Tableau workout in Power BI in which we build a segmented bar chart that contains a bar for the total amount followed by a bar that shows a categorical breakdown of that amount. This challenge involves a bit of data transformation as well as some more advanced …
2024 Week 29 | Power BI: Remake of a Tableau Segmented Bar Chart Read More
Introduction Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with a built-in theme and customize it, or create your own theme. In addition to the primary data colors, we can also define sentiment colors and divergent …
2024 Week 26 | Power BI: Reference Theme Sentiment Colors in DAX Read More
