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