Introduction A profit card tells you the result. It does not show how that result is built, which components changed, or where to investigate next. This week, build an interactive Financial Metric Map in Power BI. Start with Net profit and reveal its components one branch at a time: revenue, cost of goods sold, operating […]
2026 Week 40 | Power BI: Metric Navigator Read More »
Power BI, Workout Wednesday
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 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 One of the first “unique” chart types I ever learnt to visualise in a BI tool has since become one of my favourites, the Peas-in-a-Pod chart. This chart can be a great way to visualise the change between multiple data points. For example, in this challenge, we will be exploring how the IMDB ratings
2026 Week 29 | Power BI: Peas, Pods, & Pivoting Read More »
Power BI, Workout Wednesday
Introduction Imagine, your company hired a Chief Happiness Officer (CHO). Their job: keep the office running smoothly. Coffee stocked, ping-pong table used, no-show meetings under control. They ask for a dashboard. Your first instinct? KPI cards. One per metric, previous value, delta, nice arrow. Clean. Visual. The CHO loves it. Until there are more metrics.
2026 Week 28 | Power BI: Redesign a KPI monitor for the CHO Read More »
Power BI, Workout Wednesday