Forum Discussion
Measure
Hi,
just want to know formula for below logic how to write
- YTD <= YEP , Green
- YTD > YEP, variance between 1% - 5%, Amber
- YTD > YEP, variance > 5%, Red
plese help on above logic
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
1 Reply
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