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 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 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
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
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
Introduction Welcome to week 3 of 2025 and this challenge we will be dipping our toes into Vega, a lower-level language than vega-lite. This challenge is ideally suited to those that have dabbled in vega-lite – but don’t worry if you want to try your hand – there are a few templates to help get …
Introduction Happy Holidays and Happy New Year folks! The last dataviz challenge for 2024 and we will be creating a Christmas Family Feud game with the new Text Filters in preview – don’t forget to ensure these are enabled before participating in the challenge. Utilize as many filters as you like and prepare some conditional …
Introduction Utilising the dataset from a previous challenge (week 43), this week we are going to build a bubble likert chart. Likerts are usually ordered categorical data, and often it does not make sense to convert categories to a numerical score to find averages. Sometimes, likerts can be treated as interval data. https://www.scribbr.com/methodology/likert-scale/. For the …
Introduction This week’s challenge is to test your data storytelling skills and enhance a line chart of service desk survey responses to focus attention on important aspects. No solution file provided this week. Requirements Obtain the data Model Data Create a chart showing survey response trends Dataset This week’s dataset is downloadable from Github https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Help%20Desk.xlsx …
Introduction Ternary plots are a unique plot that is typically used to look at the mineral composition of rocks. However these plots have been adapted in data journalism for looking at voting intention in varying demographics. Each point on the plot comprises a percentage of each dimension e.g of the 65+ age demographic, 16% of …
