Showing results for 
Search instead for 
Did you mean: 
New Member

How to change the colour value for negative number in the Matrix visualization?



I am working whit Matrix visualization

The negatives numbers appears in color black

How to change the colour value for negative number in the Matrix visualization?


thanks!!! best regards

Advocate II
Advocate II

More up votes    (#,#;[Red](#,#);"-" add color to custom formula)


Note that one needs to select Values and totals for the Apply to option for this to work now

Advocate II
Advocate II

I was able to solve this issue by using a small hack.


Just select the value of minimum and maximum  to "Number".

Set the value for both minimum and maximum to "0" (zero).


It will work 🙂snap1.PNGsnap2.PNG

This helps

Hi mpandita,


This worked for me. Thank you.





Frequent Visitor

@mpandita That is a smooth move dude! Thanks!!

I guess, not exactly what you are looking for, but maybe a way to simulate what you are looking for in the best way currently available.


In the current version of PowerBI Desktop there is a simple version of Excel's "Conditional Formatting". You could leverage this, to make the background (not the font!) red(ish) by applying the following paramters:


Conditional Formatting negative values only.png


You might be not happy with the following differences compared to your expectations:

- formats the background (and not the font)

- uses shades of red depending on the actual value (and not just only one color intensitiy for all negative values)


Markus Ehrenmueller-Jensen

Hi @ssantone,

In Power BI Desktop, we are not able to specify the color of negative number. For this feature, you can vote it and add comments in the following ideas.

If you have any question, please feel free to ask.

Best Regards,

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors