Introduction Welcome back to Workout Wednesday! This week we’re creating a dynamic annotation slicer that highlights specific data points on a time series chart. Imagine you’re presenting monthly revenue trends to stakeholders who want to quickly assess performance against the typical baseline. Instead of manually pointing out values, you create an interactive chart where users …
2025 Week 45 | Power BI: Create dynamic annotations Read More
Introduction In this week’s challenge we are going to try to create a chart on rising sea levels where the y-scale of mm will display on screen in physical mm. You can try this with whichever custom visual you like, but the example laid out below will be for the utilisation of the HTML Content …
2025 Week 44 | Power BI: Utilising HTML to create actual scale charts Read More
Introduction Welcome to Week 43 of 2025! This visual was built to make change visible. The goal was not just to show numbers, but to tell a quick, visual story of how performance moves from one point to another. Each line represents a small comparison between two dates or periods. When the line is green, …
2025 Week 43 | Turning Numbers into a Story of Movement Read More
Introduction Happy Workout Wednesday, data fam! Week 42, we’re taking a step behind the visuals—because every great report deserves a great Info Page! Your report might tell the what, but your info page explains the why—and that’s where real understanding begins. No fancy tools, no measures — just thoughtful design and storytelling. Your challenge: Build an …
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
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
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
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
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
Introduction When building reports, one of the most common requests I hear from users is: “Can I see the top three, top five, or top ten items without having to look at multiple visuals?” The good news: yes, you can! And it’s cleaner than ever with numeric range parameters in Power BI. In this week’s …
