Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

variance with negative and postive KPI

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? 

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.