Power BI

2025 Week 41 | Power BI: eCommerce metrics bar-in-bar visualizations

Power BI, Workout Wednesday / By

Introduction I’ve been reading the new book Dashboards That Deliver by Andy Coatgreave, Amanda Makulec, Jeffrey Shaffer, and Steve Wexler. Chapter 14 contains an eCommerce dashboard by Dorian Banutoiu that shows how many people viewed a product, added it to their cart, and then actually purchased it. I appreciated the compact nature of what the book …

2025 Week 41 | Power BI: eCommerce metrics bar-in-bar visualizations Read More

2025 Week 40 | Power BI: Announcing the DataViz World Champion

Power BI, Workout Wednesday / By

Introduction Workout Wednesday crew! Did you know that Microsoft is now hosting a Dataviz World Championships every year, twice a year? The premise is that you create a report for a preliminary round (or rounds), and 4 finalists are then selected to compete live on-stage at the Fabric Community Conference (FabCon).  I just returned from …

2025 Week 40 | Power BI: Announcing the DataViz World Champion Read More

2025 Week 37 | Power BI: Adding a baseline bar in a bar chart

Power BI, Workout Wednesday / By

Introduction In this challenge, we are looking to add a bar with custom logic to a bar chart. Sometimes when I’m working with a customer, they want a baseline, total, or reference point to be included in the column of a column chart or the row of a table. If it’s just a matter of …

2025 Week 37 | Power BI: Adding a baseline bar in a bar chart Read More

Area between loess

2025 Week 36 | Power BI: Area between timeseries smoothing

Power BI, Workout Wednesday / By

Introduction This weeks challenge is an extension of week 21, whereby we will create a timeseries smoothing over lines rather than scatter points. The challenge here is to emphasize the difference between two populations, whilst having the details visible, but not prominent – getting the opacity/strokedash (for overlapping lines) and colour contrast (for perceptibility) right …

2025 Week 36 | Power BI: Area between timeseries smoothing Read More

2025 Week 35 | Grouped Field Parameters in a Matrix

Power BI, Workout Wednesday / By

Introduction Welcome to Week 35 of 2025!  When building reports in Power BI, one of the most common requests I hear from users is: “Can I explore different KPIs side by side without creating dozens of visuals?” The good news: yes, you can! And it’s cleaner than ever with field parameters grouped by category. In …

2025 Week 35 | Grouped Field Parameters in a Matrix Read More

2025 Week 32 | Build a Waffle Chart using Core Visuals

Power BI, Workout Wednesday / By

Introduction This week, we’re cooking up something a little different – waffle charts! Your challenge is to build a report that compares actual sales to a dynamic monthly target and visualizes progress in a clean, impactful way. Requirements Get and Prepare Data Start by downloading the CSV file provided. It contains 8 columns: ORDERNUMBER QUANTITYORDERED …

2025 Week 32 | Build a Waffle Chart using Core Visuals Read More

Screenshot of Aanor's winning Power BI report, which includes a birthday cake and a happy 10th birthday to Power BI

2025 Week 31 | Recreate a winning #PBI10 entry

Power BI, Workout Wednesday / By

Introduction This week we’re challenging you to recreate a single visual element from one of the winning reports from the #PBI10 dataviz championship. The contest took place over the past month and there were four winners, so, you have four reports to choose from! The entries in this challenge represent a wide range of visual styles, analysis, …

2025 Week 31 | Recreate a winning #PBI10 entry Read More

2025 Week 30 | Power BI: Bar chart with built-in scales 📏

Power BI, Workout Wednesday / By

Introduction Happy Workout Wednesday, data fam! This week, we’re taking bar charts to the next level—with built-in scales that visually speak for themselves! We all love a good bar chart, but sometimes you want to show progress toward a goal or segment values into performance zones – without extra visuals, DAX trickery, or custom backgrounds. Just …

2025 Week 30 | Power BI: Bar chart with built-in scales 📏 Read More

Scroll to Top