Power BI: Age Pyramid. 

Create what demographers refer to as an Age Pyramid, in which each bar represents the makeup of the US population as a whole in 5 year cohorts and create an animated Age Pyramid using data from the US Census Bureau.
Part of the Power BI Work Out Wednesday Challenges, reference below.

Data Source:

The US Census Bureau’s 2017 projections representing the years 2015 – 2060. Connect to this excel file .

*source: US Census Bureau

Challenge Requirements

• Transform the data so that you have four columns in your data table
  • Year
  • Population
  • Sex
  • Age 
• If you would rather start with a Power BI desktop that includes the modeled data, click here
• Create a measure to calculate the percent of population
• Add two custom visuals to the report:
  • Tornado Chart
  • Play Axis (dynamic slicer)
• Add a tornado chart including the fields Age, Sex, and % of Population 
• Adjust the size of the canvas to fit your age pyramid
• Add the Year to the Play Axis visual and set the animation settings to auto-start and loop
• Add a card visual to display the year
• Ensure that your data labels are clear and remove extraneous text
• Get creative with your design!

Reference: https://www.workout-wednesday.com/2021/04/27/pbi-2021-w17/

Please look at more fun examples of my skills and projects in my Power BI portfolio.

Plus here's my homepage Siri's homepage.