Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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".
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?
You can actually circumvent this problem.
Should work like you wish now.
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.
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
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |