Introduction Welcome to this week’s Workout Wednesday. This week, we are taking advantage of some new features in the February 2024 release of Power BI Desktop. We can now have bars overlap in a clustered column chart and hide the inner borders in a stacked column chart. This week, we’ll use those formatting options to …
2024 Week 9 | Power BI: Use Bar Overlap and Border Formatting Read More
Introduction I keep seeing a particular visual shared by a Denver-area meteorologist on social media. It seems to be output from weathermodels.com. I thought it might be fun to make a modified version in Power BI, so that is our challenge this week. While we don’t have native overlapping columns, there is a native solution …
2024 Week 4 | Power BI: Recreate this weather visual with overlapping columns Read More
Introduction In the December 2023 release of Power BI Desktop, some new formatting options were added for bar charts. These enhancements allow us to add borders around bars (and segments of bars for stacked bar charts), change the transparency of the fill color in a bar, and add secondary metrics to data labels. With the …
2023 Week 52 | Power BI: Format Bar Charts with Transparency, Borders, and Detail Labels Read More
Introduction The November 2023 release of Power BI Desktop includes the new button slicer visual. This visual can currently be used as a replacement for the original slicer visual when using tiles. There are more enhancements to come, but we already have a lot more control over the formatting of the slicer. We can add …
2023 Week 47 | Power BI: Use the New Button Slicer Read More
Introduction This week’s challenge looks at two options for making faceted charts with multiple measures: the Deneb custom visual and the Stacked Bar Chart core visual. The charts compare two different measures across two attributes. You’ll have to get a little creative to accomplish this in both chart types. Requirements Get the sample dataset from …
2023 Week 43 | Power BI: Faceted Stacked Bar Chart Comparison Read More
Introduction Last week’s workout caused some healthy discussion about bar chart labeling preferences and best practices. This week we will look at other ways to implement space saving labels while also showing the data labels for the each bar in a bar chart. The report shown below demonstrates 4 ways to implement bar chart labels …
Introduction Sometimes it can be useful to show all data points instead of aggregating them. That is where an instance chart, also called a strip plot or a barcode plot, can be useful. A strip plot is like a single-axis scatter plot. The symbol or shape used in the instance chart can vary, but it’s …
2023 Week 35 | Power BI: Create a Faceted Instance Chart Read More
Introduction Inspired by a Tableau Workout Wednesday from last year, we are going to make a Marimekko chart. A Marimekko chart, also known as a Mekko chart or mosaic plot, is used to visualize categorical data across two variables. Both axes use a percentage scale that determines the width or height of a bar. Think …
Introduction This week we are going to have some fun with Power Query to obtain data from a website that spans multiple pages and then visualize the data in a treemap. Treemaps are meant to display hierarchical data as a set of nested rectangles. They aren’t a great replacement for bar charts when minor differences …
2023 Week 27 | Power BI: Power Query Simple Pagination and a Treemap Read More
Introduction This week we are continuing our viz efforts inspired by the 1 dataset 100 visualizations project, presented by the Data Viz Project. Last week, Shannon challenged us to create as many visuals as possible using the core visuals available in Power BI. This week’s challenge is to create visuals using the Deneb custom visual. I have …
2023 Week 24 | Power BI: Visualize Change Between Two Points in Time with Deneb Read More
