KPI visual does not apply color correctly

[FireFighter1017]

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.. 😞

[v-mengzhu-msft]

Hi @FireFighter1017 ,

What's your version of your power bi desktop? If not the latest version, please update to the latest.

Best regards,

Community Support Team Selina zhu

[FireFighter1017]

I think it's the latest.  At least it is the latest version IT just deployed on my computer.

And just so you know, it is not only doing that on Power BI Desktop.  It is also doing it on Power BI Service as well.

I have found another scenario that seems to be working in certain conditions.

Every week we take a snpashot of orders in the backlog, and we get the aging of each order.  This KPI visual is supposed to give us the latest snapshot's average age of orders in this snapshot, as well as the past weeks trend in the background.

I had this measure that is basically AVERAGE(Fact_Backlog[Aging]) that I was using as the value of this KPI and also as the field for color coding rules.

Since it looked like the visual is taking all values into account when setting the color coding, I have modified the measure so that every time the measure is evaluated, it could only see one week at a time:

_tmp Backlog \ Average WO Age = 
VAR _enddate =
    MAX ( Fact_Backlog[SnapshotDate] )
RETURN
    CALCULATE (
        AVERAGE ( Fact_Backlog[Aging] ),
        FILTER (
            Fact_Backlog,
            Fact_Backlog[SnapshotDate] = _enddate
        )
    )

It seems to be working with the color coding for now.

But this visual definitely didn't behave this way before.

Now I'll have to review all the reports where I have used this visual to make sure it does'nt behave like this.