Forum Discussion
Textfilter in Power Query do not work randomly
I have found a way to solve the Problem:
It works if you set the datatype to text manually (even if the datatype which was automatically set already is text! (as you see in the screenshot above)). This seems to make a difference.
Impactful IndividualThis behavior can be caused by a number of factors, including data source issues, data type mismatches, incorrect filter syntax, and more. Here are some steps you can try to resolve the issue:
Check data types: Make sure the column you're trying to filter is of the text data type. If not, change the data type.
Verify the filter syntax: Make sure the filter syntax is correct.
Refresh data source: Try refreshing the data source and see if it resolves the issue.
Remove and re-add the filter: Remove the filter and then add it back again to see if that fixes the issue.
Restart Power Query: Close Power Query and then open it again to see if that fixes the issue.
Try filtering a smaller subset of the data: If the data source is large, try filtering a smaller subset of the data to see if that resolves the issue.
Try using a different method of filtering: If the text filter is not working, try using a different method of filtering such as a conditional column.
If none of these steps resolve the issue, you may need to troubleshoot further by reviewing the data source, logs, and so on.
I have found a way to solve the Problem:
It works if you set the datatype to text manually (even if the datatype which was automatically set already is text! (as you see in the screenshot above)). This seems to make a difference.
Thank you Bettina, your solution just worked for me too. Even though the column was of a number type, it just wouldn't filter zero. Once I manually set type to number - worked .
Must be a bug
Thank you