Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

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

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:

AUaero_0-1661202882774.png

 

Power BI identifies the middle values around 103,000.

AUaero_1-1661202958811.png

 

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.

AUaero_2-1661203035654.png

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.

 

Status: Delivered

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

Comments
v-cazheng-msft
Community Support
Status changed to: Accepted

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
Community Support
Status changed to: Delivered

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
Responsive Resident

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.