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

amitchandak's avatar
amitchandak
Super User
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