conditional formatting icon set

[vijayvizzu]

Hi 

I have applied simple Icon set CF on one my column in the matrix

The rule was simple, if the value greater than or equal to Zero, then green Icon, else Red icon

But still, it shows RED for zero values. unable to fix it

[MFelix]

Hi @vijayvizzu ,

You issue is that you have both syntax the same greater or equal than zero.

You need to have:

Greater than 0 less or equal to 100

Greater than minimum (or any negative value) and is less than 0

To have the minimum just delete the 0 from the field it automaticallly fills with minimum.

[vijayvizzu]

Thank you for your reply, here in this case, i want to put Greater than or equal to Zero as Green icon, so its not working, please suggest

[MFelix · Accepted solution]

Hi @vijayvizzu ,

Sorry missread it then the rules are:

Greater than or equal to 0  - less or equal to 100

Greater than minimum (or any negative value) - is less than 0

Check result below:

I'm using a column but the result is the same with a measure.