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!