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.

jgeddes's avatar
jgeddes
Super User
4 years ago

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". 

lbendlin's avatar
lbendlin
Super User
4 years ago

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]))/17

Edit: never mind, didn't see the calendar filter.

 

Note:  (MIN+MAX)/2 is faster.