Forum Discussion
Conditional formatting comparing 2 percentage columns
ahhollan , You can create a measure that returns color based on condition and used that in conditional formatting using field value option
Switch(true() ,
[actual%] < [Target%] , "Red", "Green")
Change conditions as per need
PowerBI Abstract Thesis: 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
ahhollan , You can create a measure that returns color based on condition and used that in conditional formatting using field value option
Switch(true() ,
[actual%] < [Target%] , "Red", "Green")
Change conditions as per need
PowerBI Abstract Thesis: 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