Power Query row filtering not working

[sandra_p]

I have copied a table and in this new table I want to filter out rows, that have "History field" = status

I have applied filter:

But in "History field" I can still see both values - status and Sprint

[BA_Pete · Accepted solution]

Hi @sandra_p

Have you tried trimming your History column in Power Query? Select that column, go to Format>Trim then try filtering after this step.

Pete

[amitchandak · Accepted solution]

@sandra_p , Try text.contains to check

https://docs.microsoft.com/en-us/powerquery-m/text-contains

and text.trim to trim the spaces

https://docs.microsoft.com/en-us/powerquery-m/text-trim

[az38]

Hi @sandra_p 

for me your statement works pretty good.

make sure you have refreshed the preview.

make sure all your values in Hostory field have one encoding

check how filtered data shows in the report mode

[sandra_p]

I must mention, that I tried using "equals" as well.

[BA_Pete · Accepted solution]

Hi @sandra_p

Have you tried trimming your History column in Power Query? Select that column, go to Format>Trim then try filtering after this step.

Pete

[Anonymous]

Thanks @sandra_p ..Trimming really helped me..Trimming really helped me in filtering out the data