Filter using imported list

---

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