cancel
Showing results for 
Search instead for 
Did you mean: 

Filters Interfering with Icon Conditional Formatting in Tables

I have run into an issue while using the Icon's conditional format option while in a table. In this table, I have a Utilization Percentage column, and I wanted a health indicator icon that would display the colors I wanted within certain ranges. I set rules based on the Utilization Percentage column to where 0% -> 50% is Red, 50% -> 80% is Yellow, and 80% -> 100% is Green. This was working great until I added Filters by Slicer. When selecting one of the filter options the data would be correct (Utilization Percent), but the health indicators would suddenly change to random colors. There was no logic to this as 97% would now be Red and 95% would be Green. It almost looks as if the health indicators view the filtered Utilization Percentage as a completely different number. 

 

Please let me know if a suspected user error is involved or if more information is needed. Thank you!

 

Picture is showing what happens when a filter is selected (97% is now Red when it should be Green):

Cedwards_0-1617913027578.png

 

Status: New
Comments
v-chuncz-msft
Community Support

@Cedwards 

 

"Percent" is actually a dynamic percent of the full range of all actual values, not something you should use when your column is represented as Percent format. To fix, use Number type, which is not dynamic, and then type the raw numbers before formatting. Likely 0.33 for 33%, 0.67 for 67%, etc.

Cedwards
New Member

@v-chuncz-msft Wow. Thank you so much! This fixed the issue.