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.
Yeah, it's a bit off. Dashed is median, solid is mean/average. Middle color is supposed to be white which is kinda absent.
You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/
It appears to be taking the max value of the list and subtracting the min value of the list. That number divided by two and then added to the min value to get the "middle value".
nice theory but doesn't seem to hold
middle measure = var a = summarize('IAM Performance','IAM Performance'[IAMName],"s",[$ Sales / Day]) return 0.5*(maxx(a,[s])+minx(a,[s]))/17Edit: never mind, didn't see the calendar filter.
Note: (MIN+MAX)/2 is faster.
I think you're onto something here. Using your algorithm, I come up with 106,214 as the "middle" value. This jives with with what Power BI is actually highlighting as the middle value.
Did you find this in the documentation somewhere or just figure it out? Regardless, this seems like a dumb way to find the "middle". This approach gives you average of the min and max values. The middle of a set of numbers is the median.
