Conditional formatting based on the multiple measures result

[sumachintalapan]

Hello All,

I do have multiple KPI cards (lets say 5 Cards) wanted to create a conditional formatting based on the 5 KPI values. 

lets say

KPI card 1 Values : 10

KPI card 2 Values : 20

KPI card 3 Values : 30

KPI card 4 Values : 40

KPI card 5 Values : 50

Based on the above values the KPI card 5 Values which is 50 should be color formattied and highlighted .

any suggestion ? 

[amitchandak]

@sumachintalapan , Not very clear

but  you can have measure like these and use that in conditional formatting  using field value option

KPI1 color = if( [KPI1] = maxx({[KPI1], [KPI2],[KPI3], [KPI4],[KPI5]}, [Values]), "Green", "Black")

KPI2 color = if( [KPI2] = maxx({[KPI1], [KPI2],[KPI3], [KPI4],[KPI5]}, [Values]), "Green", "Black")

[sumachintalapan]

can you please share some example PBIX file if you have any . Thanks.