Measure

[sprao]

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

[amitchandak · Accepted solution]

@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/...