Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
Does anyone know that standar ranges for KPI visualization? What is the criterium has low, medium and hight?
Thanks!
Soraia
Solved! Go to 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
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
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
Hi @SoraiaT
Based on my test, if the value <=Max Target or value >=Min Target could be yellow.
Regards,
Cherie
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
Hi @SoraiaT
Yes, it is possible.
Regards,
Cherie
Hi @SoraiaT
Attached the simplified sample for your reference.
Regards,
Cherie
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |