Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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