Forum Discussion
Unexpected Result With Matrix Conditional Formatting
Hi AUaero ,
According to the reply from the product group, Power BI implements the color gradient as a linear scale. You can set the Middle to a different value if you want, but by default Middle is the average of min/max.
They will take the idea from you into consideration for adding more Auto options to "middle".
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here's a link to the issue I've submitted. Based on jgeddes findings I guess this isn't necessarily a bug, just a dumb way of resolving the middle value. Please take a minute to go vote on this idea if you think the middle value should be the median instead of the average of the min and max values.
Gradient conditional formatting doesn't accurately... - Microsoft Power BI Community
A compromise would be to allow the developer to specify the rule that decides the "middle" color.
Worst case you would have to roll your own coloring rules.