cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Wouter1 Frequent Visitor
Frequent Visitor

Understanding the KPI visual (distance to goal)

So I recently ran into a problem with the Power Bi KPI visual. I got two KPI's, one is good when it's higer, the other good when it's lower than the previous year.

 

In the formatting pane, I configured them to show the "Goal" and also the "Distance". Now it is this this "distance" that I can't understand. As you can see in the image, the KPI on the right has a negative percentage. This appeared when I configured the KPI as "Lower is good".

 

So I see to possible meanings for this "distance".

  1. How much more or less the current value is than your target/threshold value.
  2. How much you currently have to gain or lose to achieve your target/threshold value.

fout.PNG

 

For the KPI on the right, logic 1 sounds right. For the other one it's logic 2. So there seems to be a problem. From what I can see, the distance value shouldn't change from positive to negative because you adjust the "Higher is good" setting. There should not be a connection in my mind.

 

So Anyone here with an explanation for me? Or is this maybe a bug?

3 REPLIES 3
Community Support Team
Community Support Team

Re: Understanding the KPI visual (distance to goal)

HI @Wouter1,

 

I'm not clarify for your data and measure formula, can you please share these for test?

 

>>From what I can see, the distance value shouldn't change from positive to negative because you adjust the "Higher is good" setting. There should not be a connection in my mind.

Based on you screenshot I know current value is less than previous, kpi calculation formula should similar as (current -previous)/current. (I test with your data and get result -0.601377..)


Regards,

XIaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
pedrodax Frequent Visitor
Frequent Visitor

Re: Understanding the KPI visual (distance to goal)

I have exact the same question.

 

First why Microsoft does not allow configuring % thresholds like Below 80% target Red, Between 81%-99% Amber and 100%+ Green.

 

It is not a hard thing. But it looks like there is a esoteric black box that decides the color outcome.

 

At least if we could know the triggers for each color, even if configuring is not alowed.

 

Regards

 

Pedro

PowerBI_Yonghu Occasional Visitor
Occasional Visitor

Re: Understanding the KPI visual (distance to goal)

I am having the same issue. When you say lower is good, the trend automatically change the sign which is not a good thing. 

 

One solution is to still use higher is good, the flip the green to red and red to green. 

 

But still the check sign become bad meaning and ! become good. Just not making sense.

 

Please fix.