Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Power Query Only Delete filtered rows


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

Power BI

Avatar of undefined
Last Comment
Cédric Tielemans
Avatar of Cédric Tielemans
Cédric Tielemans
Flag of Belgium image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Power BI
Power BI

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo