Select many entries in a field

[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?

Thnaks.

[v-sihou-msft]

@MattN4

You can import the Excel List into Power BI. Select the column and "Add as New Query".

It will generate a List.

Then you just add #"Filtered Rows" step in your Power Query with List.Contains() function.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJUitWJVnICsozALGcgyxjMcgGyTJRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, Value = _t]),
    #"Filtered Rows" = Table.SelectRows(Source, each List.Contains(Name,[Name])),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Name", type text}, {"Value", Int64.Type}})
in
    #"Changed Type"

Regards,

[Greg_Deckler]

In theory, you could import the list you want from Excel into a new table. Relate that table to your other table. Then, if you create calculated columns in your new table or drop the product column from the new table into a visualization along with measures then only the columns that you want will be displayed, effectively filtering the visualizations the way that you want.