Cant Remove Filter on Transform Data

[dommyw277]

Hi, i have put a filter on so i can see the csv file data and removed the bottom rows but now i can take the filter off the csv file i was filtering? Im doing something wrong obviously, can anyone help please? 🙂

[dommyw277]

Hi, wow thats a bit poor. Ok i will manipulate the csv file instead first and reimport, thanks anyway

[mlsx4]

Hi, 

If you filter data when you are using Power Query, you wouldn't be able to 'quit' the filter out of it in Model View. You should remove the steps on the right panel inside Power Query to be able to remove the filter.

Anyway, if you can share some screenshoot of the problem, it would be very helpful

[dommyw277]

Hi, i cant share the data as its confidential. I am changing in it in power query but as theres over 20 csv files, i have to filter on the one i want then delete the bottom rows then i just want to go back to see all the other csv files, surely this is possible?

[mlsx4]

Hi @dommyw277 

As far as I know, you cannot filter, remove and try to be back... 

You can use dummy data as example of what you are trying to achieve.