Filter using imported list

[MattN4]

Hi,

I have a field which is a product catalogue, I want to filter on a few hundred products but the only way I can see is to scroll through all 5124 products and tick each of the ones I want.

Is there a way of importing a list from Excel on to my report so only those products are displayed?

Thanks.

[Eric_Zhang · Accepted solution]

---

@MattN4 wrote:

Hi,

I have a field which is a product catalogue, I want to filter on a few hundred products but the only way I can see is to scroll through all 5124 products and tick each of the ones I want.

Is there a way of importing a list from Excel on to my report so only those products are displayed?

Thanks.

---

@MattN4

You can import the data table and filter table in Power BI. And then filter data table with filter table in Power Query.

Check 

let  
    dataTable=  Table.FromRows({{"Apple",10} , {"Peach",15},{"Cherry",20}}, {"category", "amount"}),

    filterTable=Table.FromRows({{"Apple"} , {"Peach"}}, {"category"}),

    filteredTable = Table.SelectRows(dataTable, each List.Contains( filterTable[category], [category] ))
      
in
    filteredTable