Help with icon conditional formatting settings

[Fusilier2]

Hi,

I have this rule set up :

However, for some reason, I currently have a value which is 0  (I've checked and it is 0 with no decimals), but the above is showing the red arrow icon in my report instead of the amber icon.

Can anybody see anything wrong in my logic above?

[Fusilier2 · Accepted solution]

Apologies everybody. I hadn't filtered the visual properly. I have done so now and all is working fine.,

[PhilipTreacy]

@Fusilier2 

Not sure how filtering would affect CF rules, can you explain please?  The CF rules should be applied regardless of any filters.

Phil

[Fusilier2]

I am using the CF rules with a measure calculation which is this month - previous month

There are visuals for different departments so obviously I need to filter to the relevent department for the CF to reflect the correct calculation.

[PhilipTreacy]

Hi @Fusilier2 

What field are you applying this formatting to?  It appears to be called . and if it is numeric then you should also have a Summarization option which you can see in this example image is Sum 

Is the data in the column you are trying to apply the formatting to numeric or is it text?

Regards

Phil

[Fusilier2]

This is the data the rule is evaluating (October - September)

30/09/2025	422.0
30/09/2025	23.0
30/09/2025	15.0
30/09/2025	100.0
30/09/2025	100.0
30/09/2025	46.0
30/09/2025	29.0
30/09/2025	27.0
30/09/2025	19.0
30/09/2025	7.0
30/09/2025	2.0
31/10/2025	418.0
31/10/2025	23.0
31/10/2025	16.0
31/10/2025	99.0
31/10/2025	102.0
31/10/2025	46.0
31/10/2025	29.0
31/10/2025	28.0
31/10/2025	19.0
31/10/2025	7.0
31/10/2025	3.0

Both months add up to 790

[KarinSzilagyi]

Hi @Fusilier2, that looks correct to me. Could you share an example showing a few rows of your table with the actual values used for the conditional formatting next to the icons? (You can crop out any other columns in the image.)