Forum Discussion

sumachintalapan's avatar
sumachintalapan
Frequent Visitor
4 years ago

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 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 ? 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      sumachintalapan
      Frequent Visitor
      4 years ago

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