Forum Discussion
Removing Specific Rows from the Dataset
Hello,
I need to remove specific, nonconsecutive rows within my dataset in Power BI. For example, I have 5 different locations (1-5) and 5 different products (A-E). I need to filter out Location 1, Product B, and Location 3, Product D. When I try to do this in the data query, it seems to remove either all products for location 1 or the specific product for all locations. When I try to use the remove rows feature, it only allows me to remove from the top or bottom, and the rows must be consecutive. I cannot seem to remove very specific rows. Please help! My data is confidential, but below is a sample with the highlighted rows as the rows I need removed from my dataset in Power BI. Thank you!!
Marie
Anonymous - Create a column that concatenates your two columns. You may have to do a type conversion for your numeric column,
Text.From([Location]) & [Product]
Then you can remove just the rows you want.
4 Replies
Add a custom column like this to get more specific
if [Location] = "Location 1" and [Product] = "Product B" then 1 else 0
Then you can just filter out the rows with 1 in the new column.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Anonymous - Create a column that concatenates your two columns. You may have to do a type conversion for your numeric column,
Text.From([Location]) & [Product]
Then you can remove just the rows you want.
