Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Power Query Only Delete filtered rows

Hi

In Power Query I want to delete rows where the "Region - Shaft" column equals "unassigned".

So I filter out all other rows then select Remove Rows >> Remove top Rows. Then I enter 8 and hit OK and I see the step "= Table.Skip(#"Filtered Rows",8)"

I only expect these rows to be deleted but when I try to unfilter it looks like all the rows are gone. Why would this be?

The first image shows all the rows. The second shows the ones I filtered and want to delete. When I have deleted these the third image shows what happens after I delete. The table appears to be empty and I cannot unfilter


User generated image
User generated imageUser generated image

ASKER CERTIFIED SOLUTION
Avatar of Cédric Tielemans
Cédric Tielemans
Flag of Belgium image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer