skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power BI Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish Community
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • US Mortality Rates 1980-2014

    US Mortality Rates 1980-2014

    08-07-2017 21:03 PM - last edited 08-07-2017 21:33 PM

    iDataDrew
    Advocate IV
    1185 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    iDataDrew
    iDataDrew Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    US Mortality Rates 1980-2014

    ‎08-07-2017 09:03 PM

    This is a re-creation of an existing data viz on the International Health Metrics and Evaluation website.

     

     Allow me to briefly lay out the features of this viz:

     

    1. Slicers at the top allow you to slice the data on Mortality Type (e.g. Cardiovascular Disease), State, and Year.

     

    2. A color scale just below the slicers provides context to the visuals.  I created this color scale with a 100% stacked column chart.  I just hid the x and y axes and used the mortality rankings as the values and as the color saturation.

     

    3. The heatmap was created using the matrix.  Typically you would have years across the top (columns); however, since there are much fewer years than states (note: District of Columbia, though not a state, is included in the dataset), it made more sense to have the states on the columns and the years on the rows.  This way it spans the entire width of the page.  The heatmap, which is colored by mortality ranking (1/dark red=high mortality rate helps you see; 52/dark blue=low mortality rating), helps you see changes over the years by each state.

     

    4. The choropleth map provides insight into regional mortality rates.

     

    5. Then you have your standard bar chart with mortality rate on color saturation.  You can drill down to the county level.

     

    6.  Lastly, you have a scatterplot across the bottom, but only the x-axis is utilized (by mortality rate) and is color formatted by mortality rate.  This helps you see the distribution of the data.  You can also drill down to the county level.  I wanted to use the Play Axis, but it doesn't seem to work if you only use one axis.  If anyone knows any way around this, please let me know.

     

    I hope you enjoy the data viz.  Please let me know if you have any recommendations or if you notice any errors.  Thank you.

     

    You can check out more of my Power BI creations at Make It PBI.

     

    eyJrIjoiM2U4ZDRlOTItNTFhNS00ODM1LTg3YTMtZTdmZjEyMGQyOTk0IiwidCI6IjZkNjM4YjFhLTMyYmYtNGJhMy1iNGI0LWU4NjU1MzcyNmZiMSIsImMiOjZ9

    Preview file
    280 KB
    USA_Mortality_Rates_1980_2014.pbix
    Labels:
    • Labels:
    • Health
    • Lifestyle
    • Politics
    Message 1 of 1
    1,185 Views
    2
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices