Forum Discussion

ERing's avatar
ERing
Post Partisan
2 years ago
Solved

Can't get simple conditional formatting applied correctly

I have a table where I'm trying to apply conditional formatting based on the value in the column, but the formatting doesn't seem to match the rule I've set. Somehow the background formatting is bein...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi ERing 
    Change your condition to :
    >=0.2945 NUMBER 
    <    0.3044 NUMBER

     

    it will work.

    I attached pbix with my example :

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

  • amitchandak's avatar
    amitchandak
    2 years ago

    ERing ,
    Update: I realized Ritaf1983 has already answered. Please consider that answer.

    When you have a ratio column the values are in the range of 0 to 1 usually

    means 25% is .25 .

     

    Also use number not Percent, Percent is for allocation not Percent Measure

     

    refer: https://youtube.com/shorts/UaQX0yOeAWE

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi ERing 
Change your condition to :
>=0.2945 NUMBER 
<0.3044 NUMBER

 

it will work.

I attached pbix with my example :

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

ERing's avatar
ERing
Post Partisan
2 years ago

Thanks Ritaf1983 

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    ERing Happy to help 🙂