Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix Conditional Formatting when all values are zero

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 t...
Tips and Tricks
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

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

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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