Introduction
This week’s challenge is a simple challenge of creating a 3D Scatter Plot with the PlotlyJS Custom Visual for Power BI.
The data shows the dominant colours of Bob Ross paintings across all episodes and seasons. The colours are plotted by hue, saturation and lightness along X, Y and Z scales.
You can extend this challenge by working with Deneb or obtaining additional Bob Ross data.
Requirements
Power Query
- Obtain the dataset from Github
- Model and load data
Power BI Desktop
Option 1:
- Obtain PlotlyJS Custom Visual from AppSource
- Create a Scatter Chart with hue along the X, saturation along the Y, and lightness along the Z axis
- Adjust the point sizes to suit
- Change the point (trace) colours to be the HSL or RGB values
Dataset
The dataset this week can be viewed at Github
https://github.com/kolky001/Workout-Wednesday-2023/blob/main/dominanthslcolours.csv
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
Share
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 available for download via Data Stories Gallery
Where is the source file ?
Hi Aditya – you can download the source data from Kerry’s Github Repo
Once in GitHub, use the … menu in the upper right corner to download the data.