topic Re: COVID19 Dashboard in Data Stories Gallery

COVID19 Dashboard

Anonymous — Wed, 08 Apr 2020 17:32:29 GMT

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

Re: COVID19 Dashboard

mike_honey — Thu, 05 Mar 2020 21:04:25 GMT

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:

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?
The data labels on the line chart at bottom-right arent readable by now, can you add tooltips and/or a Y-axis?
Can the map zoom when a Country is selected in the slicer?

Re: COVID19 Dashboard

Anonymous — Thu, 05 Mar 2020 21:45:54 GMT

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

Re: COVID19 Dashboard

mike_honey — Fri, 06 Mar 2020 18:59:50 GMT

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.

Re: COVID19 Dashboard

PowerbiGuRoo — Mon, 09 Mar 2020 16:24:12 GMT

Can we download this .pbix?

Thank you Kindly

Re: COVID19 Dashboard

Balanor — Thu, 12 Mar 2020 19:46:43 GMT

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

Re: COVID19 Dashboard

mike_honey — Thu, 12 Mar 2020 23:00:06 GMT

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

Re: COVID19 Dashboard

labuser1235 — Tue, 17 Mar 2020 10:09:30 GMT

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

Re: COVID19 Dashboard

Anonymous — Wed, 18 Mar 2020 12:04:46 GMT

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

Re: COVID19 Dashboard

labuser1235 — Wed, 18 Mar 2020 12:15:45 GMT

Anonymous Please check my post https://community.powerbi.com/t5/Desktop/Subtracting-the-previous-day-s-value-from-today-s/td-p/977879/highlight/false

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.

Re: COVID19 Dashboard

Anonymous — Wed, 18 Mar 2020 12:35:16 GMT

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

Re: COVID19 Dashboard

sirlanceohlott — Thu, 26 Mar 2020 16:42:44 GMT

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

Re: COVID19 Dashboard

Yeadeniyi — Wed, 01 Apr 2020 08:16:24 GMT

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

Re: COVID19 Dashboard

Anonymous — Thu, 02 Apr 2020 01:00:10 GMT

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).

Re: COVID19 Dashboard

Yeadeniyi — Thu, 02 Apr 2020 15:28:14 GMT

Anonymous, I was able to find my way around it following the steps. Thank you