Forum Discussion
Resolver IPower 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?
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
Community Champion
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?
SteveD2I used both the items from the drop-down list and manually entering it into the M code.
- HotChilli
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.