Help with dynamic icon rules

[Fusilier2]

This is a really basic question but I'm struggling with this!.

I'm trying to dynamically show icons depending on value.

>0

=0

<0

This are the rules I have tried but they don't seem to be working properly seem to be working:

Can anybody see where I have gone wrong please?

[SamWiseOwl · Accepted solution]

Hi @Fusilier2 
Remove the below 0 first, then the equal to zero then the greater than zero.

[rohit1991]

Hi @Fusilier2 

Could you please try below. I've tested this and it is working fine. I've also attached output screenshot for your reference.

1. Green (value > 0)

   • If value is greater than 0 and less than or equal to Max.

2. Amber (value = 0)

   • If value is equal to 0.

3. Red (value < 0)

   • If value is greater than or equal to Min and less than 0.

Conditional Fomatting Popup Screenshot

Sample Output Data Screenshot

[jaineshp · Accepted solution]

Hey @Fusilier2,

Change the second rule i.e., If value ≥ Min and ≤ Max

to : - If value > 0 AND ≤ Max → Green

To avoid overlapping with the amber rule for zero, you must exclude 0 from the green rule.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer

[SamWiseOwl · Accepted solution]

Hi @Fusilier2 
Remove the below 0 first, then the equal to zero then the greater than zero.

[Thomaslleblanc]

If the Min value is less than 0, you have a problem with 2 rules able to display. The first would be picked.

Maybe use:

1. Red - If value >= -9999999 and < 0

2. yellow if value = 0

3. green if value > 0 and <= MAX