Bidirectional filter on text column, leading zeros preventing it from working

[Anonymous]

I have two tables, in a many-to-many relationship, and when I search an asset number in a slicer, it prevents it from finding a similar value in the other table, due to a leading zero.

Is there a measure or a way to ignore a leading zero when filtering a table?

[mhossain · Accepted solution]

@Anonymous 

In the powerquery, you can clean the columns from both the table and trim the leading 0s. See below link:

https://community.powerbi.com/t5/Desktop/Remove-leading-Zero-s-in-Query/m-p/247410