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
    • 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
    • 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
    • COVID-19 Data Stories Gallery
    • COVID-19 disease / SARS-CoV-2 coronavirus outbreak...

    COVID-19 disease / SARS-CoV-2 coronavirus outbreak/epidemic/pandemic

    02-17-2020 14:48 PM - last edited 09-01-2020 05:39 AM

    avatorl
    Impactful Individual
    29999 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    avatorl
    avatorl Impactful Individual
    Impactful Individual
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    COVID-19 disease / SARS-CoV-2 coronavirus outbreak/epidemic/pandemic

    ‎02-17-2020 02:48 PM

    It's not just a dashboard, there are multple pages in the report top present data from different points of view: a page to show top 10 countries by number of cases/deaths, a page to compare countries by case fatality rate, mortality and Global Health Security Index, a tool to compare COVID-19 trends between selected countries and others.


    Updated (9/1/2020): I created the report in earlier February and I'm still changing it when I have time. Some pages are well designed, some pages still require a final touch, some pages will be removed since they are not relevant to this stage of the pandemic...

    Main data source: GitHub COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    eyJrIjoiNDE4NDk4OTQtMzA4Yi00NmZhLWE5NGEtNjY2OWUyZmIxNzFjIiwidCI6IjYzNjBkMTZhLTk3MWQtNGQzMC1hOWE5LTdiY2I0ODUzMDhlMSIsImMiOjl9

    Preview file
    44 KB
    Labels:
    • Labels:
    • COVID-19
    • Global Challenges
    • Health
    Message 1 of 11
    29,999 Views
    8
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Ion_Gomez
    Ion_Gomez
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-28-2020 02:34 PM

    Which filter is the one that you use in the first page? 

    I want to use that in our company, a filter that you can type.

    Preview file
    7 KB
    Message 9 of 11
    24,500 Views
    0
    Reply
    avatorl
    avatorl Impactful Individual
    Impactful Individual
    In response to Ion_Gomez
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-28-2020 03:21 PM

    @Ion_Gomez it's just built-in Slicer 😉

    1. Click the three dots (…) from the upper-right corner of the Slicer.
       
    2. There, you should find the option Enable search.
    Message 10 of 11
    24,496 Views
    1
    Reply
    avatorl
    avatorl Impactful Individual
    Impactful Individual
    In response to avatorl
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-21-2020 10:29 AM

    I'm starting a series of posts on my blog about How did I build my COVID-19 report

    Message 11 of 11
    17,453 Views
    0
    Reply
    nguyenngoclyna
    nguyenngoclyna
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-18-2020 01:08 AM

    Hi Avatori,

    I want to share your dashboard with citizens in Vietnam, but, my country has many people who can't read English.
    Pls, you could share it with me, isn't it?
    my email's hainguyen2209@gmail.com
    Thank you so much!
    Message 8 of 11
    28,016 Views
    0
    Reply
    avatorl
    avatorl Impactful Individual
    Impactful Individual
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-17-2020 02:52 PM

    The report is also available here:  http://avatorl.org/covid-19/ 

    Message 2 of 11
    29,950 Views
    0
    Reply
    harryfasb6000
    harryfasb6000
    Frequent Visitor
    In response to avatorl
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-26-2020 08:55 AM

    Hi Avatori,

    Great dashboard. Is it possible to get a copy of your .pbix as curious to see how you brought in the various the news feeds.

    Thanks.

    Message 3 of 11
    29,639 Views
    1
    Reply
    avatorl
    avatorl Impactful Individual
    Impactful Individual
    In response to harryfasb6000
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-22-2020 06:35 AM

    >>Is it possible to get a copy of your .pbix 

    I'm sorry, so far I'm not going to share the pbix file. But feel free to ask any questions about the report.

    Message 4 of 11
    27,454 Views
    0
    Reply
    chamue329
    chamue329 Helper II
    Helper II
    In response to avatorl
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-02-2020 12:20 PM

    Hi - you did an incredible job on this dashboard. I especially like the daily % chart that shows the Top 5 countries new case change rate.  Are you pre-calculating this in the table with Power Query or using DAX measure?  I have trended data table with dates vertically.  Any suggestion you can provided would be gratefully accepted.

     

    Steve

    Message 5 of 11
    26,091 Views
    1
    Reply
    avatorl
    avatorl Impactful Individual
    Impactful Individual
    In response to chamue329
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-14-2020 04:25 AM

    @chamue329 , @abubakrsaad, sorry for such delay with my answer. I hope you're fine, it's a tought time on this planet now.

    I used Power Query only to transform data structure, all calculations are based on DAX measures. For % of growth it's just simple today's cumulative value divided by yesterday's cumulative value.

    For all maps I used basic 'Map' visual, nothing special.

    Message 7 of 11
    24,685 Views
    0
    Reply
    abubakrsaad
    abubakrsaad
    Frequent Visitor
    In response to chamue329
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-12-2020 08:53 AM

    what the custom visual for word map?

    Message 6 of 11
    25,439 Views
    1
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • 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

    © 2023 Microsoft

    Follow Power BI

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