Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Anyone know how set Conditional formatting rule on negative numbers to red ?
I want negative numbers or percentage to red.
I try to set minimum field to blank but it don't allow me to set it.
Solved! Go to Solution.
@jdbuchanan71
Very appreciate for your effort to me.
Thank for your support.
Now this issue found already.
This picture at below that I got email from Microsoft
This resolved my issue! Thanks for that!
In Field formatting, use Red as default color for this column. This would render all values (negative or positive) in Red color.
Then use Conditional formatting to color the positive values in Green. The conditional formatting would look something like this:
Format by Rules
Based on Field
<Your Numeric Column Name>
Rules
If value is greater than or equal to 0 Number and is less than or equal to <a very large number> Number then Green
Please mark it as accepted solution if works.
Thanks and regards,
Jitendra Pandey
Thank all of you contribute to help me solve this issue. but It still not working all your mention above.
I think It's bug or error on this issue. I need to extra field in order to show red on negative values.
It doesn't make sense, right ? Why it need to add one more field in table in order to work ?
But my requirement don't need it
you can see picture at below
Hi,
This is possible by using a gradient with custom values.
Thanks! That resolved the issue! 🙂
Can you show me a screen shot of your rule with greater than -1 (NEGATIVE 1) and NUMBER and less the 0 number.
Try this for Positive and Negative numbers
This works, elegantly simple 😎
@jdbuchanan71
Very appreciate for your effort to me. but this solution isn't working.
Thank you @virakprom
Can you share your .pbix file? I have no idea why that is not working.
@jdbuchanan71
This is link of Power BI file. Thank
https://chipmonggroup-my.sharepoint.com/:u:/g/personal/virak_prom_chipmong_com/EaaFraD7GRtFmQialNFmd...
Hello @virakprom
I don't have access to your company's sharepoint. You will have to load it to something like OneDrive or DropBox and give us that link.
@jdbuchanan71
Very appreciate for your effort to me.
Thank for your support.
Now this issue found already.
This picture at below that I got email from Microsoft
Here's my solution for negative/positive percentage values:
solution for negative/positive numbers:
Hello @virakprom
You can change the type from percent to number and put a negative amount in the first field. The formatting below will format negative % from -100% to 0 as red.
The best simply solution ever, thank you.
It isn't working. but I want show percentage not decimal
Hi @virakprom ,
Please set the your conditional formatting as per screen shot below and let me know your result:
User | Count |
---|---|
134 | |
72 | |
70 | |
55 | |
54 |
User | Count |
---|---|
199 | |
95 | |
63 | |
62 | |
51 |