Bubble Chart with a Custom Overlay.
Custom page overlay, using Unpivot for additional data preparation.
Part of the Power BI Work Out Wednesday Challenges, reference below.
Data Source:
GapMinder from Data.World.
Challenge Requirements
This challenge involves a bit of data prep. Unpivot is the key to success.
- Connect to the Data.World curated dataset, which contains 4 tables
- Bring all tables into Power BI and create a data model.
- Ensure that the income, life expectancy, and population tables are related to the data geographies table.
- Build a bubble chart that shows life expectancy by average income over time
- Ensure that the colors in your bubble chart represent Region and the size of the bubble represents population size
- Build a custom page overlay that gives additional details to end-users about the data included in the report. Do not be afraid to be creative – this does not need to look like the sample! (hint: use a button and bookmark)
- Create a button on your report page that will allow users to display the custom overlay (the question mark in the sample)
- Are there any countries with an income over 50k that have an average life expectancy lower than 74?
Reference: https://www.workout-wednesday.com/2021/03/30/pbi-2021-w13/
Please see more on my Power BI portfolio, thanks!