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

[ssantone]

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

[garythomann_vac]

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]

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 🙂

[Anonymous]

This helps

[graviteja282]

Hi mpandita,

This worked for me. Thank you.

Regards,

Raviteja 

[dMac314]

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

[MEhrenmueller]

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:

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)

[v-huizhn-msft]

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