Forum Discussion
Help with conditional formating and negative + positive percentages
Hi Chilladin ,
Below are the complete steps for setting up the conditional formatting, you can follow each step to end up with the desired results:
1.Click on the drop-down arrow:
2.Click on Font color:
3.Format Style Select the second option - Rules:
4.Setting up the fields that our rules need to be based on is the measure that we created earlier:
5.Set up two rules by clicking on New rule, and finally click OK to get the final result:
Best Regards,
Zhu
Community Support Team
You don't need to apologize I am just new to PowerBI, so it's pretty confusing navigating around the many different aspects of it. I'm just thankful for you helping and leading me to the answer 🙂
If I do a conditional formatting I get a different rule so it add a < or >, instead of = that you showed me on your first reply.:
I can refer to my latest reply to amitchandak if you want to see how I tried to do it after his instructions.
So is it correct to assume:
I don't need to create a new measure, but can just use conditional formating on my percentage field?
or
Do I need to combine the measure and my percentage field?
Hi Chilladin ,
Below are the complete steps for setting up the conditional formatting, you can follow each step to end up with the desired results:
1.Click on the drop-down arrow:
2.Click on Font color:
3.Format Style Select the second option - Rules:
4.Setting up the fields that our rules need to be based on is the measure that we created earlier:
5.Set up two rules by clicking on New rule, and finally click OK to get the final result:
Best Regards,
Zhu
Community Support Team
Thank you so much for your help Zhu!
It worked and sorry for the late reply and "accept as solution" I had other tasks that suddenly got a higher priority than this one, but could finally return to it today :).Have a great day and thank you again for your patience and instructions!