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
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • 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
    • 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
    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
    • COVID19 Dashboard

    COVID19 Dashboard

    02-11-2020 15:34 PM - last edited 04-08-2020 10:32 AM

    Anonymous
    Not applicable
    32160 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    COVID19 Dashboard

    ‎02-11-2020 03:34 PM

    This is an interactive dashboard visualization of the 2019 coronavirus outbreak via time-series animation and geomapping. 

     

    I used the 'Play Axis' custom visual and DAX measures to create filter settings that would allow for progressive time-series animation. Some data transforms were required to model the source data into a more optimized time-series data model. 

     

    The source data set is made publicly available by Johns Hopkins University for educational and research purposes only.  Here is the link to their github repository:

     

    https://github.com/CSSEGISandData/COVID-19

     

    https://github.com/CSSEGISandData/COVID-19/blob/master/README.md

     

    The data is updated every day at ~23:59 UTC.

     

    Rob

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    eyJrIjoiNmEyMTRkODEtNDFkMi00MzFjLWIzZmUtNTY4NmQzNWExYmMwIiwidCI6ImYzZmY5OWM3LTUzNmItNGE2OS1hMTM3LTM4YzZiNjgxMmJlZSIsImMiOjZ9

    Preview file
    404 KB
    Labels:
    • Labels:
    • COVID-19
    • Economics
    • Government
    • Health
    • News
    • Politics
    Message 1 of 15
    32,160 Views
    16
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Yeadeniyi
    Yeadeniyi
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-01-2020 01:16 AM
    Hi Great Job! Please can you kindly share the formula you used to return the value for new cases in US when no state is selected
    Message 13 of 15
    6,324 Views
    0
    Reply
    Anonymous
    Not applicable
    In response to Yeadeniyi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-01-2020 06:00 PM
    @Yeadeniyi 
     
    Something like this should work for you, depending on your time-series table structure:
     
    _us_counties_new_cases_max =
    VAR __PREV_DAY =
            CALCULATE(
                MAX('us-counties-cases-time'[cases]),
                DATEADD('DateTable'[Date], -1,DAY),
    DateTable[Date]<=TODAY()-1
            )
        RETURN
            CALCULATE(MAX('us-counties-cases-time'[cases]) - __PREV_DAY)
     
    You could improve this DAX formula with some combination of MAX and SUMX, I was trying to clean and transform all of the data and have not refined much of my DAX measures (yet).
    Message 14 of 15
    6,303 Views
    0
    Reply
    Yeadeniyi
    Yeadeniyi
    Regular Visitor
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎04-02-2020 08:28 AM
    @Anonymous, I was able to find my way around it following the steps. Thank you
    Message 15 of 15
    6,285 Views
    0
    Reply
    sirlanceohlott
    sirlanceohlott Advocate III
    Advocate III
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-26-2020 09:42 AM

    Rob,

     

    Great job! Definitely a lot of options to slice and dice the information within your dashboard.

     

    The progressive animation is a really nice touch!

     

    -Lance M

    Message 12 of 15
    6,363 Views
    0
    Reply
    PoweredOut20
    PoweredOut20 Resolver II
    Resolver II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-18-2020 05:04 AM

    Brilliant work!

     

    I have to create something similar for my company. how did you connect exactly to the datasource? I have tried using the GITHUB connector and web connector but to no avail. Any tips would be welcomed

     

     

    Thanks

    Message 9 of 15
    20,670 Views
    0
    Reply
    labuser1235
    labuser1235 Helper IV
    Helper IV
    In response to PoweredOut20
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-18-2020 05:15 AM

    @PoweredOut20  Please check my post https://community.powerbi.com/t5/Desktop/Subtracting-the-previous-day-s-value-from-today-s/td-p/9778...

    Where you can find the PBIX file which helps you to resolve your getting source data issue, and there is also some work done in that file can be helpful in sorting things quickly.

    Message 10 of 15
    20,659 Views
    1
    Reply
    PoweredOut20
    PoweredOut20 Resolver II
    Resolver II
    In response to labuser1235
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-18-2020 05:35 AM

    Thank you so much!, this has helpped me a lot

    Message 11 of 15
    6,453 Views
    0
    Reply
    labuser1235
    labuser1235 Helper IV
    Helper IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-17-2020 03:09 AM

    Fantastic...can we get the PBIX file please it's for my learning purpose.

    Message 8 of 15
    21,339 Views
    0
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-12-2020 04:00 PM

    Hi Rob,

     

    On the maps, I think it might work better to just show the Confirmed value (which I understand includes Recovered & Deaths)? It might be overstating the bubble size to use them together? Also the map pie segments are mostly too small to select accurately, and selecting one segment then filters the other charts by that measure type (e.g. Confirmed only shown in the line charts after selecting a Confirmed segment on the map).  With a single value shown on the maps, I imagine selecting a location would show filtered line charts for all statistics.

     

    On the map zoom (my point #3 earlier), my use case is: after using the Slicer to select a Country (e.g. China, Australia), it would be good if the map zoomed to enlarge that location.  Assuming that's the built-in Map visual, you can turn on Auto zoom (under Map controls).

     

    Keep up the good (and important) work!  Let me know if you need any help.

     

    Regards, Mike

    Message 7 of 15
    23,974 Views
    1
    Reply
    Balanor
    Balanor
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-12-2020 12:46 PM

    This is awesome work!  Love the color scheme, but the data in general is laid out in a very useful way

    Message 6 of 15
    24,146 Views
    0
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-05-2020 01:04 PM

    Great work on this important topic Robert - thanks for sharing. The style is very elegant and precise. I appreciate how you've used a point-style map as country-level is less informative.

     

    I had a couple of questions:

    1. WRT to the chart at bottom-left, I'm not very familiar with the data, but I wonder if the "Recovered" figure should be subtracted from "Confirmed", rather than added?
    2. The data labels on the line chart at bottom-right arent readable by now, can you add tooltips and/or a Y-axis?
    3. Can the map zoom when a Country is selected in the slicer?
    Message 2 of 15
    28,184 Views
    0
    Reply
    Anonymous
    Not applicable
    In response to mike_honey
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-05-2020 01:45 PM

    Hey Mike,

     

    Thanks for the notes.  

     

    1. You're absolutely right, the stacked bars make the recovered & confirmed cases appear additive, when they are not.  I've reverted this back to a line chart for clarity. 

    2. I don't follow this one, sorry, as I'm seeing labels on my browser. Are you viewing on a phone?

    3. The map zoom wouldn't be super meaningful here unfortunately, as the source data doesn't contain detailed geo data below the country level. (Except for the US and China). At some point Johns Hopkins may start to include more detailed geo data. I agree with you though, I would like to view this at a more granular level as well. 

     

    Cheers,

    Rob

    Message 3 of 15
    28,156 Views
    0
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-06-2020 10:59 AM

    Thanks for the update. #2 was a browser issue, I was using the Brave browser, which is otherwise OK but does a very poor job on Power BI content. In Chrome those charts look great.  Sorry for wasting your time on that one.

    Message 4 of 15
    27,783 Views
    0
    Reply
    PowerbiGuRoo
    PowerbiGuRoo Helper I
    Helper I
    In response to mike_honey
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎03-09-2020 09:24 AM

    Can we download this .pbix?

     

    Thank you Kindly

    Message 5 of 15
    26,594 Views
    0
    Reply

    Power Platform

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

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • 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

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks