Need help

[Sreesudha_OC]

Hi All,

I am trying to get api from John Hopkins as well as WHO to develop dashboard.  

Incase if you have got it, can you please help me.

https://covid19.who.int/

Thanks

Sudha

[amitchandak]

@Sreesudha_OC , This is the source for data

https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_time_series

[Sreesudha_OC]

Thankyou Sir, i was able to figure this out. I just need one more advise. If you look , this data has got dates from Jan 2020 until 20th July 2020 and it will keep on adding.

I need to create a visualization for

1. week wise increament of covid cases in each location

2. Total number of confirmed cases in those location.  When i apply slicers.

Can you kindly advise.

Thanks

Sudha

[v-xuding-msft · Accepted solution]

Hi @Sreesudha_OC ,

Q: 1. week wise increament of covid cases in each location

A: You could configure incremental refresh to have a try.

https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/

Q: 2. Total number of confirmed cases in those location.  When i apply slicers.

A: Please try like this:

Total Sales_Country = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Country]))