Matrix Conditional Formatting when all values are zero

[Anonymous]

Hello,

I'm using conditional formatting in a matrix to set the background color based on color scale. However, when all the values in the column are zero (not null or blank), the color defaults to using the maximum color instead of the minimum color. 

Is there a way to change this behavior to use the minimum color instead? Rather than setting the values to null, as I need to keep them as zeros to include them in averages.

EDIT: Image for clarity

Thank you,

Curtis

[Anonymous]

I understand this is expected behavior, I'm asking if it's possible to change this behavior through some Power BI guru magic!

[Anonymous]

Did you ever get this solved?
I am running into the exact same problem.

[aj1973]

@Anonymous 

The Guru magic is then found in DAX. Create a DAX forumla and use it your Matrix.

[Anonymous]

How would I get DAX to emulate what I'm looking for? As far as I can tell, if all values remain the same (i.e. zero) the result will be the same (maximum color scale).