KPI standard colours - what range?

[SoraiaT]

Hi!

Does anyone know that standar ranges for KPI visualization? What is the criterium has low, medium and hight?

Thanks!

Soraia

[v-cherch-msft]

Hi @SoraiaT

If you choose 'High is good' in color coding for KPI visual.

1) The amount measure>= Target goal = Good colour

2)The amount measure < Target gogal= Bad colour

3)The Neutral colour is for when there're two target values, if the amount measure between the two values, it is Neutral Colour.

Regards,

Cherie

[SoraiaT]

Hi Cherie @v-cherch-msft,

Thank you 🙂 now I got it. Do you know if there is a way to show yelow when aproching the target and with lower deviation from the target?

My best,

Soraia

[v-cherch-msft]

Hi @SoraiaT

Based on my test, if the value <=Max Target or value >=Min Target could be yellow.

Regards,

Cherie

[SoraiaT]

Hi @v-cherch-msft,

In that case, should I create 2 new measures,

one for target less 10%

other for target more 10%

And set if less than target less 10%  it would be green

>target less 10% & <target more 10% it would yellow

>target more 10% it would be red

Do you think this is possibile on the kpi?

My best

[v-cherch-msft]

Hi @SoraiaT

Yes, it is possible.

Regards,

Cherie

[SoraiaT]

Do you know how should it set it?

[v-cherch-msft]

Hi @SoraiaT

Attached the simplified sample for your reference.

Regards,

Cherie

[SoraiaT]

It shows like having to different goals but i would like to keep on goal and show yellow when approaxing the goal. Do you know if this is possible?

[v-cherch-msft]

Hi @SoraiaT

There's no better ways to get the range when approaxing the goal. But you may set the good and bad color as the same color like black. And set the range of the measures manually.

Regards,

Cherie 

[v-cherch-msft · Accepted solution]

Hi @SoraiaT

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. 

Regards,

Cherie