2023 Week 22 | Power BI: Inverted Jittered Scatter

Introduction

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

Requirements

Power Query

Obtain the dataset from Australian Bureau of Meteorology Website
Model and load data

Power BI Desktop

Option 1:

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

Dataset

The dataset this week can be viewed at Australian Bureau of Meteorology website

http://www.bom.gov.au/jsp/ncc/cdio/weatherData/av?p_nccObsCode=139&p_display_type=dataFile&p_startYear=&p_c=&p_stn_num=023000

or file downloaded

Workout Wednesday #WoW2023 | Week 11 : LINEST Reg… – Microsoft Power BI Community

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

Solution File

Solution File available for download via Data Stories Gallery

Watch