Intermediate

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

Area charts with layered series

2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations

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

2023 Week 01 | Power BI: Use DAX to control visual display

Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new …

2023 Week 01 | Power BI: Use DAX to control visual display Read More

2022 Week 48 | Power BI: Conditional SVG Measures

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 …

2022 Week 48 | Power BI: Conditional SVG Measures Read More

2022 Week 47 | Power BI: WoW on Twitter

Introduction Welcome back to Workout Wednesday! This week we’re going to visualize Twitter data using Twitter’s API to retrieve tweets that have been made about Workout Wednesday! You have complete creative license to visualize the data in any way that you see fit. If you have a Power BI premium license, I encourage you to …

2022 Week 47 | Power BI: WoW on Twitter Read More

Scroll to Top