Forum Discussion
Measure
- 4 years ago
sprao ,
Assume YTD and YEP are measures you have. Create a measure and use that in conditional formatting using the field value option
Switch ( True() ,
[YTD] <= [YEP] , "Green" ,
[YTD] <[YEP] *1.05 , "Amber",
[YTD] >=[YEP] *1.05, "Red"
)
Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
sprao ,
Assume YTD and YEP are measures you have. Create a measure and use that in conditional formatting using the field value option
Switch ( True() ,
[YTD] <= [YEP] , "Green" ,
[YTD] <[YEP] *1.05 , "Amber",
[YTD] >=[YEP] *1.05, "Red"
)
Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539