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 here is key!
We will be using the Deneb custom visual for this task, whilst overall average lines can be calculated, plotting an area between two loess lines is more challenging – so give it a go.
BONUS POINTS for creating a hover action that shows the difference in height (cm) between the two genders.
BONUS POINTS AGAIN for creating SVG sparklines of the overall average difference between genders for regions in a hierarchal text slicer (core visual currently in preview).
Don’t forget to cite your source.
Happy Vizin’
Kez
Requirements
- Obtain the data
- Obtain Deneb from Appsource
- Create a line chart coloured by gender and details broken out by country
- Using a transform function create a LOESS regression on date
- Use the LOESS transform output to create a lines coloured by category
- Layer an opaque area mark between the two LOESS lines (this may require some folding and/or pivoting of data)
- Format your chart and add desired amount of interactivity
Dataset
Share
After you finish your workout, share on Bluesky or LinkedIn using the hashtags #WOW2025 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.
Solution
Coming soon.