Intermediate

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

8 Comments / Power BI, Workout Wednesday / By

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

Power BI, Workout Wednesday / By

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

1 Comment / Power BI / By

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

3 Comments / Power BI, Workout Wednesday / By

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

3 Comments / Power BI, Workout Wednesday / By

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 »