Introduction
Welcome back to Workout Wednesday! This week we’re exploring parts to a whole using a waffle chart and unemployment data.
This visual was inspired by Steven Ponce, whose work has been a great source of inspiration for me. It also builds on my previous Workout Wednesday waffle chart, giving me an opportunity to revisit the visual and take it in a different direction.
The most challenging—and probably my favorite—part of this visual is the DAX.
Let’s make some art!
Requirements
- Import the data and shape it to support the required visuals in the report.
- Create a date table.
- Create a grid table.
- Use a scatter plot to create a waffle visual.
- Create dynamic color measures.
- Build a Dynamic Legend.
Dataset
Retrieve the data from Bureau of Labor & Statistics. There are two datasets, one for volume and one for rate. In the dropdown, choose Civilian unemployment, then select Show table underneath the chart. Next choose Civilian unemployment rate, then select Show table underneath the chart.
Share
After you finish your workout, share on Bluesky or LinkedIn using the hashtags #WOW2026 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. On LinkedIn tag James Stratton.