Forum Discussion

swarnalvr's avatar
swarnalvr
Frequent Visitor
1 year ago

conditional formatting

Hi Team,  i searched but couldn't produce the right result.

My query is when the  weigh percentage(coming directly from the datset)  is

1. between  100.000 to 100.0001 should show green traffic light

2. between 100.000 to 99.9999 should show green traffic lght

3.else red

tried below but not right results

 

 

 

 

Need Help

5 Replies

    • swarnalvr's avatar
      swarnalvr
      Frequent Visitor
      1 year ago

      no it is not working changing to percent as well

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, swarnalvr 

    Thanks for Angith_Nair's reply. After testing, everything works fine on this side, you can use Number's filter criteria to filter the data, and convert your percentages to decimals to fill in the filter box.


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum