Forum Discussion
Power Query Keeps FIltering Rows Instead of Deleting them
christeddy
Please try removing all non printable and extra characters first:
1. Select the Column you want to filter; select type: text in that column.
2.1 Transform> Format> Trim2.2 Transform> Format > Clean
3. Filter empty cells
If this does not work please try Adding a Column where you can select the characters from the column you want to filter.4.1 Insert the next sentence if you want to keep letters and numbers:
Text.Select([YourColumn], {"a".."z", "A".."Z", "0".."9"})
Finally filter empty cells.
I hope this helps. if so please mark it as a solution. Kudos are welcome.
4.2 Inster this sentence if you only want to keep numbers:
Text.Select([YourColumn], {"0".."9"})
A filter in Power Query truly removes the rows. A filter in Power BI UI or in DAX "only" hides those rows.
Note that null/BLANK() is not the same as an empty string. Also note that you may see (blank) when you have referential integrity violations. That is by design.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523