I've got KPI visuals comparing several of the most recent month's values to their respective averages, and I noticed that the visual never actually shows the neutral color. Even if the value for the month is exactly the average, it shows the negative color rather than the neutral. Apparently, "Neutral" only comes into play if you provide two values, and the most recent value is somewhere between those two values.
So I made some quick measures for "Average +5%" and "Average -5%", which work just fine. But the KPI visual now shows the goal as two values, neither of which is the actual average. It's functional, but a little difficult to intuit.
I'm wondering if there's a cleaner way to do this. To put the Average in the KPI Trend field, and only show the Average as its Goal (rather than two other values), but to still use the neutral color if this month's value is within 5% of that average.
