Forum Discussion

Helper I

6 years ago

Solved

Power Query row filtering not working

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
6 years ago
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
6 years ago
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

5 Replies

sandra_p
Helper I
6 years ago
I must mention, that I tried using "equals" as well.
- BA_Pete
  Super User
  6 years ago
  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
    Not applicable
    3 years ago
    Thanks sandra_p ..Trimming really helped me..Trimming really helped me in filtering out the data
az38
Community Champion
6 years ago
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
amitchandak
Super User
6 years ago
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