Conditional formatting on multiple conditions

[winterbloom]

Hello,

I am banging my head against the wall trying to solve this problem. I hope you help.

I have a table visual made up of fields from multiple tables.

I need to do conditional formatting on the Variance $ column. The variance is Budget minus Actual (measure). 

These are the conditions for the formatting:

The background colour should be green IF the variance is positive and IE Type is E.
The colour should be red if the variance is positive and IE Type is I.
The colour should be red if the variance is negative and IE Type is E.

The colour should be green if the variance is negative and IE Type is I.

The IE Type is a value/attribute, not a measure.

Please help!

[amitchandak]

@winterbloom , You can have measure like

Switch(True(),

max(Table[Type]) = "E" && [Varinace]>=0, "Green",

max(Table[Type]) = "1" && [Varinace]<0, "Red",

// add other conditions

)

Use this measure in conditional formatting using field value option

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...