Forum Discussion

AUaero's avatar
AUaero
Responsive Resident
4 years ago
Solved

Unexpected Result With Matrix Conditional Formatting

Hi all, I'm getting an unexpected result when applying conditional formatting to a matrix visual. Take a look at this formatted column.  The conditional formatting is set up as a gradient with the l...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

lbendlin's avatar
lbendlin
Super User
3 years ago

It is likely caused by your nested measures.  The formatting works as expected for simple values

 

 

AUaero's avatar
AUaero
Responsive Resident
3 years ago

lbendlin I think you just got lucky with the set you tested with.  The average of the min and max ((7+1)/2) is 4, which is also happens to be the median of your set.  I tested using just a bunch of random numbers and get the same result as I do with the nested measures in the PBIX.  The median of this set is 48, but that isn't in the middle of the highlighted area.