Conditional Formatting

[HeyThatsKJ]

Hello everyone, I'm experiencing an issue with using Conditional Formatting in a Matrix table. The attached image should illustrate the problem clearly. I have set thresholds, and while 90% of the values follow the formatting rules, some do not. Do you have any suggestions?

[v-kaiyue-msft · Accepted solution]

Hi  @HeyThatsKJ ,

Thanks for the reply from @jdbuchanan71 , please allow me to provide another insight:

I noticed that what you are showing in your matrix is the maximum value of the field and what is set in the rule is the sum of the field, hence the unexpected situation.

If you want to be consistent, set the same aggregation as required.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[HeyThatsKJ]

Thank you Clara! That was exactly the issue, much appreciation!

[jdbuchanan71]

That must be it, nice catch Clara.

[jdbuchanan71]

That is very odd.  Can you try changing the very lowest setting to >= 0 Percent and the very hightest setting to <= 100 Percent:

The 'Percent' setting does not look at the number in the field but the number compared to the whole set of numbers so it is >= the very lowest number in the range (0 percent) and at the other end it is <= the very highest number in the range (100 percent).