Intermediate – Page 7 – Workout Wednesday

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

1 Comment / Power BI / By Meagan Longoria

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 »

Power BI report containing a calendar heatmap

2023 Week 06 | Power BI: Create a Calendar Heatmap

1 Comment / Power BI / By Meagan Longoria

Introduction For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered. Requirements Create a calendar visual: Show day of the week on rows and week on columns. (Hint: If you get stuck on …

2023 Week 06 | Power BI: Create a Calendar Heatmap Read More »

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

3 Comments / Power BI, Workout Wednesday / By Meagan Longoria

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 Shannon Lindsay

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 50 | Power BI: Santa Training Game

Power BI, Workout Wednesday / By Rob Saunders

Introduction Every year, Santa needs to prepare for Christmas day. There are so many gifts and so many children but also so little time. This means Santa often has to hurl gifts across long distances to save vital time. For this week’s challenge, we are creating a training game for Santa where he can set …

2022 Week 50 | Power BI: Santa Training Game Read More »

2022 Week 48 | Power BI: Conditional SVG Measures

Power BI, Workout Wednesday / By Meagan Longoria

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

2 Comments / Power BI, Workout Wednesday / By Shannon Lindsay

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 »

2022 Week 46 | Power BI: My Second Deneb

Power BI, Workout Wednesday / By Spencer Baucke

Introduction During week 42’s community month challenge brought to us by Thys van der Westhuizen – Thys built on my week 37 challenge – My First Deneb. For that week’s challenge I built out three basic bar charts using Deneb visuals, and subsequently, Thys continued to build a few more amazing visuals in his challenge. …

2022 Week 46 | Power BI: My Second Deneb Read More »

#WOW2022 W43: Advanced Formatting by Jeremy Anderson

2 Comments / community, Power BI, Workout Wednesday / By Jeremy Anderson

Introduction Conditional formatting is a robust feature in Power BI that you can leverage to help users gain insights. Typically, we see conditional formatting applied to the table and matrix visuals. For example, you might apply a background color, font color, or icons to the values based on a set of rules. Conditional formatting of …

#WOW2022 W43: Advanced Formatting by Jeremy Anderson Read More »

2022 Week 42 | Power BI: Deneb Custom Visuals

Power BI, Workout Wednesday / By Thys van der Westhuizen

Introduction I was recently asked by Rob Saunders if I would like to assist with a #WorkoutWednesday PowerBI challenge. To be seen in the same crowd with Kerry, Shannon, Meagan, Spencer, and Rob is such an honour. Cue the onset of imposter syndrome. After that feeling passed, Rob and I decided to continue with the …

2022 Week 42 | Power BI: Deneb Custom Visuals Read More »