Color code Card / KPI

[Anonymous]

Good Morning and Happy Holidays!

For a Plan to Actual KPI, I am using a Card with a measure in it 

aPlantoActual = Format((([YTD Sales Actual SS]-[YTD Sales Plan SS])/[YTD Sales Plan SS]), "Percent")

If the result is positive, I would like to show the numbers in green; if negative, then in Red.  

I tried formatting in the Data Label and selecting color and then fx.  I select rules.

It does not let me select aPlantoActual - it is grayed out.  

Please suggest how to do this.

Thanks,

Pavan

[amitchandak · Accepted solution]

@Anonymous , Create a measure like and use it in conditional formatting using field value option

color =

var _1 = divide([YTD Sales Actual SS]-[YTD Sales Plan SS]), [YTD Sales Plan SS])

return

if(_1 >=0,"Green", "Red")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Anonymous]

Excellent!

Happy Holidays and Best Wishes for the New Year!

Pavan