Forum Discussion

Suprith's avatar
Suprith
Frequent Visitor
7 years ago

Conditional formatting based on a 2 columns

Hello All, 

 

Can anyone please help in formatting the table with colors, based on 2 condition,

 

For particular column ( say, Today) where the value is less than 10, mark the KPI column as Green , if its above 10 then color it with Red. But here is the catch, the table has rows with different counters in it, CPU threshold differs with other counters in the table, 

 

Conditional formatting should not just be dependent on Today's value instead it should also consider Object type. 

For CPU, threshold is 10, if its less than 10 (green) and more than 10 (red)

For Memory, threshold is 600, if its less than 600(green) and more than 600 (red)

 

Object       Today            KPI

CPU           2.91603         ?
Disk           836.614503   ?

Memory    702.328244   ?

 

 

Tips and Tricks

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Suprith,

     

    For your scenario, it seems that the new feature of August Version Power BI Desktop Conditional formatting by values could help you. 

     

    Please refer to this document.

     

    Best Regards,

    Cherry

    • Suprith's avatar
      Suprith
      Frequent Visitor
      7 years ago

      Thanks Cherry, but thats not i am refrring to. Let me gexplain it with the screenshot, 

      For eg, I need to color the circle in KPILight column as red , if Today value exceeds say 80 for Countername called Processor utilization and Object being CPU. 

      And Mark KPI light as Red if Avg Disk read Latency is gretater than 10ms .

       

      So i am trying to color the KPI light based on certain value (threhsold) for Countername like '%..............(different counter names).............%'