Forum Discussion
Conditional formatting not working when filter with a slicer
Hi all,
I hope you are well and safe.
I am having an issue when I am using a slicer to filter weeks on my report. I made a simple conditional formatting where if the value is greater than 99% the background is green as listed below:
But when I select a filter por example week 11 the following happens:
The amount is lower than 99% but still green.
Have you guys encountered an issue like this?
Thank you in advance
Anonymous You need to use 'number' not 'percent' in your conditional formatting:
Percent refers to the total number of values, so when you have a filter with only 1 value, that single values makes up 100% of the number of values.
When you have a filter that filters down to 2 values, a single value is 50% of the total number of values, so the greatest one would be highlighted in green (at 100%) and the lower one would be at 50%.
When you have 3 values, they each account for 33% of the total number of values,
and so on.
Hope that helps?
1 Reply
- AllisonKennedy
Community Champion
Anonymous You need to use 'number' not 'percent' in your conditional formatting:
Percent refers to the total number of values, so when you have a filter with only 1 value, that single values makes up 100% of the number of values.
When you have a filter that filters down to 2 values, a single value is 50% of the total number of values, so the greatest one would be highlighted in green (at 100%) and the lower one would be at 50%.
When you have 3 values, they each account for 33% of the total number of values,
and so on.
Hope that helps?