Avatar of Murray Brown
Murray Brown
Flag 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





Power BI

Avatar of undefined
Last Comment
Cédric Tielemans

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Cédric Tielemans

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61