Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

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

OTFCsquared_0-1622754420972.png

 

Thank you,

Curtis

24 REPLIES 24
Anonymous
Not applicable

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

Anonymous
Not applicable

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

aj1973
Community Champion
Community Champion

@Anonymous 

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

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Anonymous
Not applicable

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors