Forum Discussion
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...
I understand this is expected behavior, I'm asking if it's possible to change this behavior through some Power BI guru magic!
Anonymous
The Guru magic is then found in DAX. Create a DAX forumla and use it your Matrix.
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).