Forum Discussion

marry's avatar
marry
Icon for Helper I rankHelper I
2 years ago
Solved

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

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 li...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
    marry
    2 years ago

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

     

    Best regards,

    Mary Chen

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

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's avatar
marry
Icon for Helper I rankHelper I
2 years ago

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

 

Best regards,

Mary Chen

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

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