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.
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
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |