conditional formatting

[swarnalvr]

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

[Anonymous]

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

[Angith_Nair]

Hi @swarnalvr 

In the conditional formatting section, use Percent instead of Number and try.

[swarnalvr]

no it is not working changing to percent as well

[Angith_Nair]

Can you share the pbix file?

[swarnalvr]

Cannot share because of security reasons , i have to maintain threshold on both columns.