Removing Specific Rows from the Dataset

[Anonymous]

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

[amitchandak]

@Anonymous , refer

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=a1cfd615-a55f-4ef1-a60e-2b5d8b7c3d88&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

https://community.powerbi.com/t5/Desktop/M-Power-Query-Removing-entire-rows-based-on-condition/td-p/367563

https://www.quora.com/In-Power-Query-can-I-remove-rows-based-on-a-particular-value-in-a-column

[mahoneypat]

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

[Greg_Deckler · Accepted solution]

@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.

[Anonymous]

insert palm to face for not thinking about this. Thank you!!!!