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
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
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 🙂
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)
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.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!