How to display scores in different color and include "Date" play axis?

[PBI_newuser]

Hi, I would like the city to change color based on the NPS score for the date. Below is the sample data. I would like to have the average NPS score by city. How to have the "date" play axis to view the NPS score in each city from day to day?

• NPS score – 9 to 10 – Green
• NPS score – 8 - Yellow
• NPS score – 0 to 7 - Red

Date	City	Job	NPS
07/11/2021	NY	J-123	2
07/11/2021	OH	J-234	7
07/11/2021	OH	J-345	9
07/11/2021	OH	J-456	8
07/11/2021	CA	J-567	9
07/11/2021	CA	J-678	5
07/11/2021	TX	J-789	4
07/11/2021	OH	J-900	3
07/11/2021	OH	J-1011	7
07/12/2021	TX	J-1122	9
07/12/2021	TX	J-1233	10
07/12/2021	TX	J-1344	6
07/12/2021	NY	J-1455	9
07/12/2021	CA	J-1566	4
07/13/2021	TX	J-1677	5
07/13/2021	CA	J-1788	7
07/13/2021	CA	J-1899	9
07/13/2021	CA	J-2010	4
07/13/2021	OH	J-2121	8
07/13/2021	OH	J-2232	9

[amitchandak]

@PBI_newuser , Create a measure like below and use that in conditional formatting using field value option

Assuming NPS is measure or use sum(Table[NPS]) or avg as per need

Switch(true(),

[NPS]>= 9,  "Green",

[NPS]>= 8,  "Red",

"Yellow"

)

If need add Play axis visual from custom visual and put date on that

refer if needed

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

How to use Play Axis Visual: https://www.youtube.com/watch?v=dhClPq0cPvE&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=34

[PBI_newuser]

Hi @amitchandak , I am not sure why the chart didn't display all the Average NPS results on the specific date  but it shows by city.

For example, I would like the chart to display all the NPS results on 1st July when I click play on the Play Axis.

Now when I click the play button on Play Axis, it shows city by city on 1st July.