Forum Discussion

SteveD2's avatar
SteveD2
Resolver I
6 years ago
Solved

Power Query is not filtering Table as selected?

I never seen this before. Usually, power query is bulletproof. Choose a column, filter what you want and bingo, that's what you get.

Below is a screenshot of a table where I am excluding a value from table to be returned. Yet, the table returns with the value still present. Why?

Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    Experiment with the "Text Filters" options, e.g. "begins with...." and "does not begin with".

    Also I suggest using Trim and/or Clean from the Transform menu to get to the bottom of this.

5 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    6 years ago

    There could be a space or hidden character in there.  Did you type the line of code or did you use the 'Text Filters' from the column dropdown?

    • SteveD2's avatar
      SteveD2
      Resolver I
      6 years ago

      I used both the items from the drop-down list and manually entering it into the M code.

      • HotChilli's avatar
        HotChilli
        Community Champion
        6 years ago

        Experiment with the "Text Filters" options, e.g. "begins with...." and "does not begin with".

        Also I suggest using Trim and/or Clean from the Transform menu to get to the bottom of this.