Forum Discussion

alexcatala's avatar
alexcatala
Helper IV
5 years ago
Solved

Exclude rows

Hi, I am trying to filter a column excluding 2 job titles, but it doesn't work.   I have tried in the Query Editor with the main filter and setting "does not contain", but doesn't work.   Any oth...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi alexcatala 

    If you start with data like this in the Query Editor

     

    Click on the filter button on the Job Title column and uncheck the jobs you want to remove and click OK

     

    Leaving you with this

     

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

AlB's avatar
AlB
Community Champion
5 years ago

Hi alexcatala 

How exactly did you try the "does not contain", with the AND or the OR?

Have you tried, on the filtering option in PQ, just to untick  Assitant Manager and  Supervisor?

IF you show some sample data we can probably work it out

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

Cheers 

 

  • alexcatala's avatar
    alexcatala
    Helper IV
    5 years ago

    Hi AlB 

     

    I went into the Power Query and I have used does not contain " Assistant Manager" and " Supervisor".

     

    The problem some of the jobs have also more text after "Assistant Manager" : Ex. Assistant Manager - London