variance with negative and postive KPI

[Anonymous]

hi

I have the scnerio that i need show the KPI of variance % having anything less than -10% is red and from -10 to 10 is green and again anything beyond 10 is again red . Is this possible to show in paypay KPI visual .

and i have another scnerio also

-10 to -5 yellow

<-10 is red

-5 to 0 is green

from +ve scale

0 to 5 green

5 to 10 yellow

>10 red

Is this possible scnerio to show for variance % value in any KPI visual? 

[v-juanli-msft]

Hi @Anonymous 

As tested, it is impossible to achieve this goal in the default KPI visual.

I can work with some other method.

Import "Card with States by OKViz" from market place,

create measures 

v = (SUM(Sheet5[indicator])-SUM(Sheet5[goal]))/SUM(Sheet5[goal])

condition = IF([v]<-0.1||[v]>0.1,1,2)

variance = "("&100*[v]&"%"&")"

Turn off "Distance" under "Goals" option for the "KPI" visual.

Move ""Card with States by OKViz"  visual on the "KPI" visual as above.

As for your other scenario, please change the measure[condition] to play.

See details in my pbix.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.