Forum Discussion
KPI visual - Low is good
Hi v-huizhn-msft,
yeah, I get it, but problem is when I set "Low is good" and value is 15,1% and goal is 13%, visual shows me distance as "-16,13%", however result should be "+16,13%" (as you write) - I explained it above.
So I think it's a bug.
Jiri
Hi jiri_siroky,
It's not a bug. Please see the Sean posted. When you set low is god. The value is better as smaller(13% is better than 15.1%), so there is 16.13% differance to goal, so the result is negative. Wish this explaination is clear.
Best Regards,
Angelia
Hi v-huizhn-msft,
yes, 15,1% is by 16,13% higher then 13%. So it should be +16,13%.
In your explanation, how would it work when value would be 10,9%? It's at distance to goal by 16,13% (from 13%) as well. So distance would be -16,13% from both 10,9% and 15,1%. When "Goal" is hidden, only variation in KPI visual would be color and exclamation/check mark which doesnt seem righ.
Other explanation - you know your goal (13%) and distance from goal (-16,15%). With these two informations, how would you ever be able to recognize if actual value is 10,9% or 15,1%
In Sean post, he shows how custom visual KPI Indicator works with these values and it works correctly IMHO. Unfortunately custom visuals are not suported for .ppt export and dont support number formattiing, so its not option for us.
Best,
Jiri
Hi @jiri_siroky,
If goal is 13%, and you set the Color coding as "High is Good". If the distance is +16.15%(positive), you actual value is 15.1%. If the distance is -16.15%(negative), you actual value is 10.9%. Conversly, the result is opposite.
In addition, the first of solution Sean posted is a KPI visual in Power BI desktop. The second part is custom visual.
Thanks,
AngeliaHi v-huizhn-msft,
so you say that when "Low is Good" is set, goal is 13% and value is 10,9%, then distance is "+16,15%"? But this cannot be right, its mathematically wrong!
Distance between 10,9% is always less than 13% by 16,15%, so there has to be -. Similarly 15,1% is always higher than 13% by 16,15%, so there has to be +. Option between "Low is Good" and "High is Good" should affect just color and check/exclamation mark, not a math. sign.
I understand what you mean that when value is better than plan, there should be + and when value is worst than plan, there should be -. However minus sign doesnt have to be interpreted as negative, resp. bad. It can easily be positive, resp. good. And its even common practice in other BI tools for Low is Good KPIs. KPI Indicator works that way too.
I dont understand reference on Sean post, because in first part he just demonstrates, how to solve +/- issue by change color in "High is Good" mode, but finds out then there is issue with check/exclamation marks. In second part he shows that KPI Indicator custom visual works correctly. Basicly he confirms what I am saying all the time.
Best,
Jiri