Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago

Conditional formatting not working properly

Hi all

 

I am using a conditional formatting with the following rules.

 

If equal to 1 then green

If >= 0 and less than 0 then red

If greater thaan 1 then red

 

 

As pointed above in the blue arrows, some values with 100% are not showing the green, while others are.

 

How can I make the 100% values show a green value?

 

The values don't have extra decimals.

 

Thanks.

Need Help
Show and Tell

16 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi o59393 ,

     

    Logic looks fine, what is checkmix in your data? Better to share the pbix to us if you don't have any Confidential Information.

     

    Best Regards,

    Jay

  • FrankAT's avatar
    FrankAT
    Community Champion
    6 years ago

    Hi o59393 ,

    try the following logic:

    • if is 1 => green
    • if is <> 1 => red

     

    Regards FrankAT

    • o59393's avatar
      o59393
      Post Prodigy
      6 years ago

      Hi FrankAT 

       

      What would be the <> option?

       

      Also, please consider that if it is greater than 1 it should be red. Green is only for =1.


      I only have these:

       

       

      Thanks.

      • FrankAT's avatar
        FrankAT
        Community Champion
        6 years ago

        Hi o59393 ,

        yes you are right, that's may fault. Here is my solution:

         

         

        Regards FrankAT

  • mhossain's avatar
    mhossain
    Solution Sage
    6 years ago

    o59393 

    If you apply green criteria as  " greater then equal to 0.99999".

    Agree with FrankAT  those reds must be not equal to100.00% in pbi if probably increase decimal to 9 digit probably.

      • mhossain's avatar
        mhossain
        Solution Sage
        6 years ago

        o59393 

         

        0.99999 will go with number (not the percent) :), I am sure you must be doing correctly.