Forum Discussion

Chilladin's avatar
Chilladin
Frequent Visitor
1 year ago
Solved

Help with conditional formating and negative + positive percentages

Hello,   I want to use the conditional formating option to make all the negative values green and the positive values red.   So all the values with a - infront it green and the only one pos...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the helpful reply from amitchandak.

 

Hi Chilladin ,

 

You can also create a measure and use it to set the conditional formating, for example:

Measure = IF(MAX('Table'[Column1])<=0,"RED","GREEN")

The result is as follows:

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

 

 

  • Chilladin's avatar
    Chilladin
    Frequent Visitor
    1 year ago

    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 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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

       

      • Chilladin's avatar
        Chilladin
        Frequent Visitor
        1 year ago

        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?