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.
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,
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
This is link of Power BI file. Thank
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.
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.
Hi @virakprom ,
Please set the your conditional formatting as per screen shot below and let me know your result:
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%.
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.
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!
We are excited to announce the Power BI Super Users!
Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.