cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Conditional formatting negative numbers red

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.

photo_2019-08-06_11-30-35.jpg

18 REPLIES 18
Highlighted

@jdbuchanan71 
Very appreciate for your effort to me. but this solution isn't working. 


Reports.PNG

Highlighted

Thank you @virakprom 

Can you share your .pbix file?  I have no idea why that is not working.

Highlighted
Highlighted

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.

Highlighted

@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
Issue.PNG

View solution in original post

Highlighted

Hello @virakprom 

That is good to know, thank you for sharing.

Highlighted

Try this for Positive and Negative numbers

 
Capture.PNGCapture1.PNG
Highlighted
Helper I
Helper I

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

Highlighted

The best simply solution ever, thank you.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors