Conditional Formatting based on Single Measure

[mcpato]

Hi All,

I have a matrix table with several columns and rows.  The values are dynamic based on the code below as I had to apply different formats in the same table.

How do I apply conditional formatting when I have a single measure? For example, I would like to have Green Background with white font if Total Open $ is greater than Total Pipeline.

Thanks

[amitchandak]

@mcpato , Based on what I got

Have a measure using the meausres

if([Total Open $] > [Total Pipeline], "Green", "red")

Same way create for font, use blank(), if you want default color

USe the above measures in conditional formatting using the field value option

You can create a complex measure using a switch

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[mcpato]

Hi amitchandak,

Thanks for your help I was trying to replicate that but it seems the conditional formatting is highlighting the whole column. I have some filters applied to that table but it seems is not filtering by rows.

This is my field value I'm using for conditional formatting. 

And I re defined the Switch Total Open $ measure: 

Not sure why is not working, my guess is that the switch total open $ measure (needed for the different formats for the different columns) is causing the issue.

Hope you can help me!