Gradient conditional formatting doesn't accurately identify the middle value in a set

[AUaero]

When applying gradient conditional formatting to a set of values in visuals that support conditional formatting, Power BI doesn't accurately identify the "middle" value.  Please see this thread for an example:
Re: Unexpected Result With Matrix Conditional Form... - Microsoft Power BI Community

Here is a link to a PBIX that replicates the issue.

https://1drv.ms/u/s!AtHPCBKFQogGgsM-5tPOl07xWgWLjQ?e=hrveq0

Take this set of numbers:

Values
164,851
134,694
127,643
113,004
112,673
103,391
101,497
99,743
88,794
87,134
80,565
75,178
65,032
61,872
60,729
52,404
47,576

Load thes values into a matrix or table and apply conditional formatting as a gradient with low, middle, and high values as such:

Power BI identifies the middle values around 103,000.

The actual median value (i.e. the middle) is 88,794.  It appears that Power BI calculates the middle by taking the average of the min and the max of the values in the column.

It would seem more intuitive that Power BI would identify the "middle" value as the median of the set, not the average of the min and max.

[v-cazheng-msft]

Hi @AUaero,

This issue has been reported internally(ICM 329637339). Will sync here once there is any update.

Best Regards,    

Community Support Team _ Caiyun

[v-cazheng-msft]

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 _ Caiyun

[AUaero]

Thanks for the update.  I strongly feel that having an option to set the "middle" value to the median of the set would be a great improvement over the current implementation.