cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Suprith
Frequent Visitor

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   ?

 

 

3 REPLIES 3
v-piga-msft Resident Rockstar
Resident Rockstar

Re: Conditional formatting based on a 2 columns

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Suprith
Frequent Visitor

Re: Conditional formatting based on a 2 columns

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

KPI Color_1.png

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).............%'

 

 

Highlighted
cncnvr
Frequent Visitor

Re: Conditional formatting based on a 2 columns

Has anyone got solution on this?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors