Intermediate

2023 Week 40 | Power BI: Bar chart label bonanza

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 …

2023 Week 40 | Power BI: Bar chart label bonanza Read More

2023 Week 39 | Power BI: Bar chart custom labels

Introduction This week we’re revisiting Meagan’s challenge where we built a bar chart with long labels. We’re going to use a trick recently unveiled by Bas (@howtopowerbi on Twitter) to create custom labels for bar charts. If you have long labels in your bar chart, they may be truncated depending on the size of the …

2023 Week 39 | Power BI: Bar chart custom labels Read More

A strip plot

2023 Week 35 | Power BI: Create a Faceted Instance Chart

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

2023 Week 31 | Power BI: Create a Marimekko chart

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 …

2023 Week 31 | Power BI: Create a Marimekko chart Read More

2023 Week 30 | Power BI: Build a smooth line chart

Introduction Welcome back to Workout Wednesday! This week we’re building a line chart using the new smoothing feature that was released this month! This week’s challenge was inspired by Andy Kreibel’s Makeover Monday challenge. We’re exploring the disappearing sea ice in the Antarctic using a line chart, looking at the extent of sea ice in millions of …

2023 Week 30 | Power BI: Build a smooth line chart Read More

2023 Week 27 | Power BI: Power Query Simple Pagination and a Treemap

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

2023 Week 24 | Power BI: Visualize Change Between Two Points in Time with Deneb

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

2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks

Introduction This week’s challenge is provided by Guest Contributor Ben Ferry aka Power BI Guy. Requirements Power Query Transform data (hint unpivot and reduce the number of columns) Load Data Power BI Desktop Create a Measure for the Sum of the values column Create a measure to rank the characters based on the measure you …

2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks Read More

2023 Week 16 | Power BI: Measure Format Strings and Conditionally Formatted Titles

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

Scroll to Top