Introduction
Hello and welcome back to Workout Wednesday! If you’re joining us for the first time, be sure to check out our complete list of challenges.
This week we’re looking at data from the American Academy Awards, also known as the Oscars. The Oscars are awards for artistic and technical merit for the American film industry and are considered by some to be the most prestigious awards in the US entertainment industry.
This week you’ll use the Infographic Designer custom visual to create an isotype chart. For those of you that completed Meagan’s 2021 challenge this might look familiar 
You’ll also add a little custom formatting, some bookmarks and buttons, and a custom (report page) tooltip!
Requirements
Get and Transform Data
- Get data from a csv
- Keep only the rows and columns that you need
Prepare Data and Get Images
- Create two measures.
- 1) Nominations by film
- 2) Selected category (this will be used to display which category users have selected from the slicer)
- Get any background images you may want/need.
- I used images from the Academy Awards site and used PowerPoint to create my background.
- I also used the WhatFont add-in to try to match fonts as close as possible
Create Report Visuals
- Use the Infographic Designer custom visual to create a bar chart. Then use an image of your choice to turn it into an Isotype.
- Add a slicer and style it to match the report.
- Add either a text box or a shape to add text that informs users which categories they have selected. I used a shape because it has more formatting options.
- Use buttons to create the appearance of the slicer, and use bookmarks to make the slicer appear and disappear.
- be sure to de-select Data in the bookmark options.
- Check your tab order and add alt text to ensure your report is accessible.
Share Your Work
- Your visuals do not have to match the challenge exactly! Get creative and share your work with us on social media.
Dataset
The dataset this week can be viewed on Kaggle or downloaded directly (as a csv).
Share
After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @JSBaucke, @MMarie, @shan_gsd, and @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
Download the solution file