How to automatically remove Power BI rows if text length=1

[marry]

Hello everyone,

I would like to entirely remove the rows if text length=1 for the Manufacturing Product Location Code. 1 column.

For example, in below row 13 & row 14, the text lengh=1, would like to remove the data.

Please help, thanks. 

[Ritaf1983 · Accepted solution]

Hi @marry 
You can add a length column:

Filter out 1:

and remove the unnecessary column

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[marry · Accepted solution]

Hello @Rita, Appreciated your help!!!!!I can successfully removed those rows. Thanks.

Best regards,

Mary Chen

[Ritaf1983 · Accepted solution]

Hi @marry 
You can add a length column:

Filter out 1:

and remove the unnecessary column

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[marry · Accepted solution]

Hello @Rita, Appreciated your help!!!!!I can successfully removed those rows. Thanks.

Best regards,

Mary Chen

[Ritaf1983 · Accepted solution]

Hi again @marry  🙂
Happy to help please consider Accepting it as the solution to help the other members find it more quickly.