Forum Discussion
Solved
Textfilter in Power Query do not work randomly
I have the problem from time to time that simple text filters in Power Query do not work. Just to be clear: I work a lot with PowerBI and usually it works as intended, but now I have a file where I'm...
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.
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