Introduction
This week, we are making a Power BI version of a previous Tableau challenge by Donna Coles. We are making small multiple spiral charts, also called satellite charts. Satellite charts can be used to show percentages when values exceed 100%. Rather than creating one circle like a donut chart, the line spirals out to create a new circle for every additional 100%.
I created this using the HTML Content visual, but you are welcome to use any visual you’d like to complete the challenge.
Dataset
This week’s challenge uses the same data as the Tableau exercise, which can be found on Google Drive here: https://drive.google.com/drive/folders/1FUWVtJ6aq9RdcDIJ7814BNUEJl-di021?usp=sharing
You just need the CSV file and not the scaffolding Excel file.
Requirements
1. Retrieve the data from https://drive.google.com/drive/folders/1FUWVtJ6aq9RdcDIJ7814BNUEJl-di021?usp=sharing. You can connect to it online or download the CSV file and reference it locally from Power BI Desktop.
2. Build a trellis (small multiples) of satellite charts displaying the Food Self-Sufficiency Ratio in Japan for FY2019 for all Prefectures.
3. Each satellite chart should colour code the spiral to differentiate the ranges – you can use any colour palette you wish – colours I’ve used below
- < 100%: orange #E07B00
- >= 100% and < 200%: blue #0072B2
- >=200%: pink #C2185B
4. Label each spiral with the percentage value and the prefecture name.
5. Conditionally format the font color for the percentage value to match the color at the end of the spiral.
Share
After you finish your workout, share on BlueSky or LinkedIn using the hashtags #WOW2026 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko (on BlueSky).