cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

1 ACCEPTED 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
Issue.PNG

View solution in original post

18 REPLIES 18
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

Frequent Visitor

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

1.png2.PNG

@virakprom 

Can you show me a screen shot of your rule with greater than -1 (NEGATIVE 1) and NUMBER and less the 0 number.

negativeformat2.jpg

Try this for Positive and Negative numbers

 
Capture.PNGCapture1.PNG

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


Reports.PNG

Thank you @virakprom 

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

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

View solution in original post

Hello @virakprom 

That is good to know, thank you for sharing.

Super User II
Super User II

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.
negativeformaat.jpg

The best simply solution ever, thank you.

It isn't working. but I want show percentage not decimalUntitled.png

Hi @virakprom ,

 

Please set the your conditional formatting as per screen shot below and let me know your result:

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly : HR Analytics Report , Hotel Management Report, and Sales Analysis Report

It still not work. I try to follow like you mention at above.

Untitled.pngUser role administrator.PNG

@virakprom 

In your example -26 % is the same as -.26.  If you format the number with 

Greater than -1 NUMBER and is less than 0 NUMBER that is the same as saying -100% and 0%.

conditionalformatnegatives.jpg

When you use the % setting it is looking at the percentage of your data meaning, if you have 100 data points and pick Less than 50 percent it will format the first 50 data points.

 

Hi @virakprom ,

 

Is it possible for you to give me sample of just 5-10 rows of data file so that I can try it at my end?

Not want to real data just create similar data and send file here.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly : HR Analytics Report , Hotel Management Report, and Sales Analysis Report

Hi @virakprom,

 

After seeting the comditional formattin as per screen shot below I have got the expected result i.e. negative values in red color.

 

Please mark this answer as a solution If I answered your question!

 

Capture.PNGres.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly : HR Analytics Report , Hotel Management Report, and Sales Analysis Report

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors