Forum Discussion
Conditional formatting based on attribute
I have unpivoted columns on attribute- CY, Budget and SPLY , how do I enter conditional formatting for specific PM% example to calculate Product Margin% for CY ,if I select CY, then CY PM% -Budge...
Anonymous , create a color measure and use that conditional formatting with field values
Color = if([CY PM% ]> [Budget PM] ,"green","red")
refer: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values