Forum Discussion
Transform Data - Remove Multiple Rows
Good morning,
Thanks to everyone who has answered my recent queries on this forum, they've really helped me get going with Power Bi.
So I'm hoping somebody can also tell me what I'm missing here, before I import a spreadsheet to work with I gather the data can be transformed but I can't see how to remove multiple rows. Like, I don't want rows 1-10 but can't see how to take them away in one go.
I'm sure there's something simple that I'm not seeing so if anybody knows that would be appreciated.
Thanks in advance
3 Replies
- vojtechsimaSuper User
- danextianSuper User
Hi Bankesy26-_
In home tab there are options to remove/skip/keep rows
Beyond what is available from the GUI, I would create conditional/custom column to that will determine whether a rows is to be kept or not based on certain conditions. This column is to be used to filter the table.
- FreemanZSuper User