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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ssantone
New Member

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

hello!!!

 

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

7 REPLIES 7
garythomann_vac
Advocate III
Advocate III

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

https://ideas.powerbi.com/ideas/idea/?ideaid=c08e3e42-2b77-4cae-9fd9-a51c599e2cbb

https://ideas.powerbi.com/ideas/idea/?ideaid=c26285eb-e1ed-4b7d-986c-2bcb7cc351d9

 

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

mpandita
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

Anonymous
Not applicable

This helps

Hi mpandita,

 

This worked for me. Thank you.

 

Regards,

Raviteja 

 

@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
@MEhrenmueller
v-huizhn-msft
Employee
Employee

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.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15310341-conditional-formatting-i...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9588453-conditional-formatting-th...

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


Best Regards,
Angelia

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.