Power Query is not filtering Table as selected?

[SteveD2]

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?

[HotChilli]

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]

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

[HotChilli · Accepted solution]

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.

[SteveD2]

Using begins with or contains resulted in the same issue. However, using either Clean or Trim or both fixed the issue.

[HotChilli]

Glad you got it sorted.  Every similar case I've seen has a space or a hidden character.