Forum Discussion
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 fro...
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.
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?
I used both the items from the drop-down list and manually entering it into the M code.
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.