2023 Week 22 | Power BI: Inverted Jittered Scatter


This week’s challenge uses Deneb custom visual to create a jittered scatter with inverted axis plus a bubble plot with labels.



Power Query
  1. Obtain the dataset from Australian Bureau of Meteorology Website
  2. Model and load data
Power BI Desktop

Option 1:

  1. Obtain Deneb Custom Visual from AppSource
  2. Create a Scatter Chart with point mark encoding Month on X Axis, Rainfall on Y Axis.
  3. Ensure scatter is at Year granuality
  4. Jitter the scatter by utilising xOffset encoding and using random function with DAX or Vega-Lite.
  5. Position X Axis at top of graph and ensure X Axis sort is correct
  6. Invert the Y Axis / Ensure the Y Axis is descending
  7. In the same visual join (concatenate) a second chart, OR, create a second Deneb visual
  8. For the second visual, create a bubble plot using a point or circle mark sized by the average rainfall by month across all years
  9. Layer a text mark with average rainfall values



After you finish your workout, share on Twitter using the hashtags #WOW2023 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 File available for download via Data Stories Gallery

2 thoughts on “2023 Week 22 | Power BI: Inverted Jittered Scatter”

  1. Just to note that the links to the data source are for the recent chocolate workout viz

Comments are closed.

Scroll to Top