Introduction
Welcome back to Workout Wednesday! This week we’re recreating a really neat viz that was originally created by Flávio Matos for the Tableau team back in 2023. Flavio created the Periodic Table of Wine, with an option for users to select the food they’ll be eating to help them pair the perfect wine.
Today, we’re going to recreate Flávio’s Periodic Table using a matrix in Power BI! This requires a little modeling trick and some conditional formatting, but is otherwise fairly straightforward. Join us to create your own Periodic Table of Wine!
Requirements
Beginner: Get data model from starter file
- Download the Power BI desktop starter file
- Go through the tables, model and measures to try to understand what you’re going to be working with.
Intermediate: Get and transform data
- Import data from Data.World using the connector in Power BI desktop
- Model data
- Model your data so that you end up with:
- a color code for the wine type
- a row rank to help create the columns in the matrix (how many times does a wine appear in a row)
- a category sort, so that the wine categories appear in the order we want them to in the matrix
- I didn’t accomplish this on my own! I had to refer to Stephanie Bruno’s blog post on Adding a row rank based on a different column with Power Query
- Create measures to display the desired background and text color
- Model your data so that you end up with:
Create visuals
- Create a matrix displaying the:
- Category on the rows
- Row rank on the columns
- Wine abbreviation on the values
- Add a slicer to allow users to select a food pairing
- Hint: use a disconnected table to cross highlight rather than filter
- Add a legend (I used a table)
- 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 contrast standards.
- I strayed from the original slightly by making the text white on the red background, and lightening up the green color.
- As always, mix up the design in any way you see fit! This should be fun!
Dataset
You can find this week’s data on Data.World or use the pre-built model in the starter .pbix file.
Share
After you finish your workout, share on Twitter or LinkedIn using the hashtags #WOW2024 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.
please post viedos
Hi Ray! Thanks for your comment 🙂 We try to either post the solution file or post a video, depending on our bandwidth. We’re all volunteers and we’re trying our very best to provide resources for the community. I’ll make a note that you’re interested in this one and see if I can find some time. In the meantime, please explore the solution file and feel free to ask any questions you have here in this thread. Thanks!