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
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
Introduction You’ve probably seen the default Power BI tooltip that lists values like Sales, Profit, or Enrollment. While that’s useful, it doesn’t always explain what those numbers mean. Sentence template tooltips let you turn those values into a natural sentence… making your reports easier to understand without creating a custom tooltip page. Where can you
2026 Week 27 | Power BI: Create Smarter Tooltips with Sentence Template Tooltips Read More »
Power BI, Workout Wednesday