Forum Discussion
winterbloom
3 years agoFrequent Visitor
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 formatti...
amitchandak
3 years agoSuper User
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