Introduction Two sites of the same walk-in clinic report the same average wait: 14.8 minutes at Site A, 14.8 minutes at Site B. On a KPI card they are twins, and there is nothing to discuss. Then you look at the 2,400 individual waits. Site A runs mostly quick, with a tail that drags out […]
2026 Week 39 | Power BI: Histograms with adjustable bin width Read More »
Power BI, Workout Wednesday
Introduction For this week’s Workout Wednesday challenge, we’re diving into a creative visual design trick that Fotiana Yan thinks you’re going to love trying out! (and I agree!) Picture this: you have a stakeholder who wants sleek, colour-shifting progress rings for every country where they sell products to track progress toward a target, complete with
2026 Week 38 | Power BI: SVG Donuts Read More »
Power BI, Workout Wednesday
Introduction Happy National Guacamole Day! As a big fan of guac, I wanted to celebrate by bringing together two of my favorite things- Power BI and guacamole. Because why simply enjoy a bowl of guac when you can also turn it into a data visualization? An Icon Matrix uses simple icons instead of repeating the
2026 Week 37 | Power BI: Categorical Icon Matrix Read More »
Power BI, Workout Wednesday
Introduction Welcome back to Workout Wednesday! This week we’re exploring parts to a whole using a waffle chart and unemployment data. This visual was inspired by Steven Ponce, whose work has been a great source of inspiration for me. It also builds on my previous Workout Wednesday waffle chart, giving me an opportunity to revisit
2026 Week 36 | Power BI: Create an Unemployment Waffle Chart Read More »
Power BI, Workout Wednesday
Introduction Traditional customer rankings tell us who generates the most revenue, but they do not explain what those customers buy. A customer may be highly valuable and still buy almost entirely from one product category – which makes the next conversation much clearer than a generic “upsell” message. This week, build a Customer Cross-Sell Map in
2026 Week 35 | Power BI: Ternary Charts for Cross-Sell Read More »
Power BI, Workout Wednesday
Introduction Last week’s bump chart reminded me of one of our early challenges from 2021, where David turned a ribbon chart into a bump chart. We’ve done other bump chart challenges over the years, so give them a try if you haven’t already. This made me curious about trends in chart selection in our challenges.
2026 Week 34 | Power BI: Visualizing WoW Chart Choices Read More »
Power BI, Workout Wednesday
Introduction A bump chart is a fun way to see how rankings change over time. It makes those ups and downs really easy to follow, without getting lost in a bunch of numbers. You can quickly spot who’s moving up, who’s dropping down, and who’s staying consistent. Think of it as turning rankings into a
2026 Week 33 | Power BI: Bump Chart using Native Line Chart Read More »
Power BI, Workout Wednesday
Introduction This week we are exploring the Pareto Principle; the 80:20 rule, which states that roughly 80% of our consequences from from 20% of causes. Inspired by the #WorkoutWednesday by Lisa Hitch, we are going to see if 20% of our Superstore customers make up 80% of our Total Sales. To visually aid our users,
2026 Week 32 | Power BI: Pareto Chart with Colored Backgrounds Read More »
Power BI, Workout Wednesday
Introduction This week, we are utilising new features from the July 2026 Power BI update. With this update, conditional formatting can be now be applied on graphs with a categorical legend. This weeks challenge will look to create a cumulative line graph of vaccination rates across population groups (either age or ethnicity), banded by %
2026 Week 31 | Power BI: Conditional Formatting Categorical Gradients Read More »
Power BI, Workout Wednesday
Introduction This week, we have another new contributor to Workout Wednesday for Power BI: Cameron Ayre. Give Cameron’s challenge a try! This week, we’re creating smoothed lines with a handy LOESS measure. We’ll use it to turn noisy data like this: Into this: Kerry Kolosko challenged us to do this last year , with Deneb
2026 Week 30 | Power BI: LOESS with DAX and Core Visuals Read More »
Power BI, Workout Wednesday