Forum Discussion
Conditional formatting on multiple conditions
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!
1 Reply
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
