Scatter chart with play axis - need help!

[Anonymous]

Hi

I am making a report with Johns Hopkins Covid-19 data. I tried to create a scatter chart with Confirmed% (count of confirmed cases/population) and death% (count of death/population) as x-and y-axis, and Country in the field of Details and Date in the field of play axis. Please see the sample data below:

Date (D/M/Y),Value,Status,DIM LOCATION.Index,Population (2020),Confirmed %,death %,Index

09 October 2020	41368	Confirmed	177	6871292	0.60%		67942
10 October 2020	41686	Confirmed	177	6871292	0.61%		67943
11 October 2020	42712	Confirmed	177	6871292	0.62%		67944
09 October 2020	104129	Confirmed	179	5106626	2.04%		82324
10 October 2020	104129	Confirmed	179	5106626	2.04%		82325
11 October 2020	105890	Confirmed	179	5106626	2.07%		82326
09 October 2020	81696	Confirmed	178	28435940	0.29%		109396
10 October 2020	82453	Confirmed	178	28435940	0.29%		109397
11 October 2020	83137	Confirmed	178	28435940	0.29%		109398
09 October 2020	621	Death	177	6871292		0.01%	171991
10 October 2020	623	Death	177	6871292		0.01%	171992
11 October 2020	631	Death	177	6871292		0.01%	171993
09 October 2020	1009	Death	179	5106626		0.02%	184843
10 October 2020	1009	Death	179	5106626		0.02%	184844
11 October 2020	1038	Death	179	5106626		0.02%	184845
09 October 2020	684	Death	178	28435940		0.00%	209035
10 October 2020	691	Death	178	28435940		0.00%	209036
11 October 2020	697	Death	178	28435940		0.00%	209037

Before I put Date in the Play axis, everything works well.

However, after putting Date in the field of play axis, the chart doesn't work anymore

Can anyone help? 

Many thanks

Jane

[Anonymous]

Hiya

It just solved itself....probably just a bug. Thank you for everything!

Jing

[Anonymous]

Hi @Anonymous 

Make 2 measures = divide(calculate(count(status),status = "confirmed"),average(population)

Same for death. Post this drag date in play axis, it will work.

Kindly mark this as accepted

[Anonymous]

Hi nishantchawla

Thank you for your prompt reply. However, it still doesn't work. 😞

Thanks.

Jane

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

I did not find any problems by testing your sample data, would you mind sharing your .pbix file?