Forum Discussion

LRCSG's avatar
LRCSG
Icon for Helper I rankHelper I
4 years ago

Conditioning Formatting Not Working According to User Defined Rules

I created a rule that any score of ITR less than 75.7% is to have an icon next to it.

Both table A and table 5 have the same rules for the conditioning formatting but it doesn't work properly in table A.

Does anyone know what I'm doing wrong here? T

 

 

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    LRCSG change the percent to number in conditional formatting and change 75.7 to .757 (decimal 757)

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

    • LRCSG's avatar
      LRCSG
      Icon for Helper I rankHelper I
      4 years ago

      Hello parry2k ,

      The problem is the 75.7 is a measure. changing the format to number doesn't solve this problem.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi LRCSG ,

     

    Does the [sample] column have sub-hierarchy?

    It's hard to tell what is wrong only by the screenshots. Better to share the data model and the formula to us.

     

    Best Regards,

    Jay