Forum Discussion

Fusilier2's avatar
Fusilier2
Helper V
1 year ago
Solved

Help with dynamic icon rules

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?

 

 

 

Need Help
  • jaineshp's avatar
    jaineshp
    1 year ago

    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

4 Replies

  • Thomaslleblanc's avatar
    Thomaslleblanc
    Super User
    1 year ago

    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

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

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

     

     

  • jaineshp's avatar
    jaineshp
    Memorable Member
    1 year ago

    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

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    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