Forum Discussion
KPI visual - Low is good
Hey Greg_Deckler and Sean,
Thanks for you replies.
At first, I was thinking its matter of perspective as you said, but more I think about it I am sure its misleading and mathematically wrong how it works now. Quickly I can write two reasons:
- you are effectively above your goal (13%) by 16,15% - I cannot find case when I would interpret this as "we are below goal". Trust me, I tried to defend this way of interpretation to myself (which would be more comfortable that solving this problem on community as I am not english native speaker :) ) , but I wasnt successful. Or can you find way how to interpret this?
- you can hide "Goal" - in this case you get red 15.1% witch exclamation mark and below it you can see (-16.15%) which will be surely intepret as "you are bellow goal by 16.15%" (in this case consumer of report would think goal is 18,01%...). Yes, U dont have to hide "Goal", however when Goal isnt effectively goal, but its value from past day/week/month/year you have to, because there is no way, how change this label.
ad KPI Indicator custom visuals - yes, here it works corretly (according to my opinion), but as I wrote above, custom visuals operate on library which doesnt currently support number formatting (according to one of developers of PBI custom visuals - (not this one)), which is block for us :(
Best & thx,
Jiri
Hi jiri_siroky,
You have understand how it works, right? Goals - when set to On, the visual displays the goal and the distance from the goal as a percentage. If you set the high is good in Color coding, it your value is high the goal, it will show positive. Otherwise, the result is opposite. For your result, you must set "low is good" in Color coding. 16.15%=(15.1%(value)-13%(goal))/13%(goal).
Please feel free to ask if you have any other issue. If you have resolved it, please mark the helpful reply as answer, more people will benefit it.
Thanks,
Angelia
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,
AngeliaHi 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