Forum Discussion

sandra_p's avatar
sandra_p
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 an...
Need Help
sandra_p's avatar
sandra_p
Helper I
6 years ago

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

BA_Pete's avatar
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's avatar
    Anonymous
    Not applicable
    3 years ago

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