Introduction
Welcome back to Workout Wednesday! We’re taking it back to basics this week and creating a bar chart that uses small multiples and conditional formatting. We’re using the #MakeoverMonday team’s data on New Year’s Resolutions and the design is inspired by a Makeover Monday participant!
A huge thank you to Ela Piwowarska for creating her submission and posting it on Twitter! I was inspired by your clean design and it’s a great opportunity for all of us to practice the basics in the new year!
Requirements
- Import data from Data.World using your method of choice. Note: There are 2 files in the project. You just have to choose one of them.
- In Power Query, shape the data so that the headers make sense and the percentages are accurately displayed.
*Hint: unpivot the data and you’ll only need to use the divide function once to go from a whole number to a decimal - Create a measure for your conditional formatting! The goal is to highlight the max value by age group.
*Hint: use ALLEXCEPT in your measure to ensure that the age group is not included in the ALL filter (meaning, so we look at the max value by age group instead of by all age groups) - Create a bar chart with the resolution on the Y axis, Value on the X axis, and Age Group as the small multiples.
- add conditional formatting to the bar color using the measure you created and format your bar chart to remove noise and make font readable
- Add a title and any other design elements that you’d like!
- Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum standards.
Dataset
You can find this week’s data on Data.World. A huge thanks to the #MakeoverMonday team for curating this dataset!
Data.World requires you to create a free account to access the data. You may use the Data.World connector in Power BI or download the file to your local machine and connect to it there.
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 the data stories gallery.