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 like to remove the data.

Please help, thanks. 

 

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.

3 Replies

  • 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.