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.
Go to Solution.
@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. Thankhttps://chipmonggroup-my.sharepoint.com/:u:/g/personal/virak_prom_chipmong_com/EaaFraD7GRtFmQialNFmd...
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
View solution in original post
That is good to know, thank you for sharing.
Try this for Positive and Negative numbers
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>
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,
The best simply solution ever, thank you.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.