Forum Discussion
Conditional Formatting based on Single Measure
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
2 Replies
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Hi 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!
