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
Hello Zhu,
Thank you for the reply.
This got me the furthest out of the many YouTube tutorials, ChatGPT Prompts and messing around myself in PowerBI.
I'm pretty close to what I want, but instead of the numbers that you've got there I've only gotten the "Red" + "Greens" do I need to somehow combine the measure and my table?
Table:
The code/string:
And I sure will press "Accept as Solution" when I've found something that works. Thanks for the reminder 🙂
Hi Chilladin ,
I'm sorry I didn't explain it clearly, what we need is conditional formatting for the percentage field, not for the measure created, also the measure is written with “GREEN” and “RED” just to differentiate, you can use any number or text instead. Depending on your picture, just change it to a conditional formatting of the preceding fields.
Best Regards,
Zhu
Community Support Team