I have used KPI visuals in the past and I have a problem with one specific application where the color coding rules are weirdly applied.
This is the exact same visual, nothing's changed except the filters applied and the measure used for the color coding is the same as the one displayed as callout value.
This KPI shoould be green when the value is below the target, and gradient from yellow to red when the value is 20 to 30 and red when over 30.
I tried with a simple 2 color gradient
Then figured out that values over 30 may not get applied correctly, so I added a middle value:
But still, without any filters applied other than the standard filters, 30,5 still turns up as yellow-ish.
Standard filters implies a relative date filter on the last 52 calendar weeks, and a divsion filter
Here's the visual's data table:
I also tried recreating this visual from scratch ending up with the same result.
After playing with different filters and analyzing the results, it looks like it is not using the last value for color coding but rather the whole table of values. Because as soon as I start filtering out the first dates, the color changes towards red...
This used to work like a charm a year ago...
Now I have found a way to make this work using Rules only:
But then it's the other way around that does not work anymore...
As per rules defined previously, this should be yellow.. 😞
Hi @FireFighter1017 ,
What's your version of your power bi desktop? If not the latest version, please update to the latest.
Community Support Team Selina zhu