Power BI

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

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

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 »

Area between loess

2025 Week 36 | Power BI: Area between timeseries smoothing

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 32 | Build a Waffle Chart using Core Visuals

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

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 📏

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 »