Murray Brown
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
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.