Forum Discussion

Suprith's avatar
Suprith
Frequent Visitor
8 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...
Tips and Tricks
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 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
8 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).............%'