Conditioning Formatting Not Working According to U...

LRCSG · ‎03-09-2022

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

Anonymous · ‎03-18-2022

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

parry2k · ‎03-09-2022

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.