Forum Discussion
Conditional formatting based on the multiple measures result
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 ...
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")
can you please share some example PBIX file if you have any . Thanks.