Author name: Kerry Kolosko

2026 Week 43 | Power BI: Visualising Lottery Patterns

Power BI, Workout Wednesday /

Introduction This week’s challenge we are visualising lottery draws. Lotteries are random, so whilst patterns that emerge may look pretty or interesting, they may not be insightful. What does your local lottery look like when visualised? Dataset Data for this challenge can be obtained from GitHub.https://github.com/JDsnyke/saturday-tatts-lotto-scraper/blob/main/supplementary_numbers.csv Requirements Data: Obtain the data from the link above […]

2026 Week 43 | Power BI: Visualising Lottery Patterns Read More »

Power BI, Workout Wednesday

2026 Week 31 | Power BI: Conditional Formatting Categorical Gradients

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

2026 Week 30 | Power BI: LOESS with DAX and Core Visuals

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

2026 Week 24 | Power BI : Infographic Makeover

Power BI, Workout Wednesday /

Introduction In this week’s challenge we are replicating or doing a makeover on a bodily injuries Infographic, with your choice of two datasets. The design inspiration comes from Safe Work Australia’s Key Statistics   Use your imagination and think about ways you can improve the visual presentation of your dataset of choice. Extra points for

2026 Week 24 | Power BI : Infographic Makeover Read More »

Power BI, Workout Wednesday
Week 15

2026 Week 15 | Power BI: Exploring and Enhancing the new Theme

Power BI, Workout Wednesday /

Introduction In this week’s challenge we are exploring the new Power BI Theme that is in Preview : https://powerbi.microsoft.com/en-us/blog/deep-dive-into-modern-visual-defaults-and-customizing-theme-improvements-preview/   The new theme comes with new chart defaults and additional Style Presets.   The challenge is to set your own defaults by downloading the JSON Theme file and modifying it.   You can use a

2026 Week 15 | Power BI: Exploring and Enhancing the new Theme Read More »

Power BI, Workout Wednesday
actual scale sea level rises

2025 Week 44 | Power BI: Utilising HTML to create actual scale charts

Power BI, Workout Wednesday /

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 »

Power BI, Workout Wednesday
Area between loess

2025 Week 36 | Power BI: Area between timeseries smoothing

Power BI, Workout Wednesday /

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 »

Power BI, Workout Wednesday

2025 Week 21 | Power BI: Scatterplot / Timeseries Smoothing

1 Comment / Power BI, Workout Wednesday /

Introduction When looking at timeseries data, we may encounter high variability from one week to the next, creating highly jagged and difficult to read charts. There are a number of techniques to smooth the lines to better depict trend. Some may use rolling averages, others, like YouGov, use LOESS regression. https://yougov.co.uk/topics/society/trackers/how-often-brits-exercise In this weeks challenge

2025 Week 21 | Power BI: Scatterplot / Timeseries Smoothing Read More »

Power BI, Workout Wednesday
Dr Who Story Arc Diagram

2025 Week 11 | Power BI: Can you create a (story) arc diagram with core visuals?

Power BI, Workout Wednesday /

Introduction Welcome to week 11 of Workout Wednesday 2025. This week’s challenge is to recreate the Dr Who Villain story arc’s visual depicted below showing the timelines of the first and last season of Villain appearances or, to challenge you to create your own data visualisation about Dr Who Villains. Perhaps you will recreate The

2025 Week 11 | Power BI: Can you create a (story) arc diagram with core visuals? Read More »

Power BI, Workout Wednesday
Embedded charts from Datawrapper and Our World in Data

2025 Week 6 | Power BI: Can you embed charts from Web?

Power BI, Workout Wednesday /

Introduction Welcome to week 6 of Workout Wednesday 2025. In this week’s challenge we will be exploring other charting options used across the web and how these can be embedded into Power BI Desktop. Using publicly accessible charts and data, we will utilise the HTML content visual to embed interactive charts within iFrames. The examples

2025 Week 6 | Power BI: Can you embed charts from Web? Read More »

Power BI, Workout Wednesday