How to pass delimited input value which should be able to filter the report ?

[Anonymous]

Suppose We have 2*2 excel source like below. 

Name	Value
A	100
B	200
C	300
D	400
E	500
F	600

I want to have a filter which takes delimited values like <<A,B>> and filter data on above dataset and gives me

Name	Value
A	100
B	200

[V-lianl-msft]

1) Add a parameter as text.

2) Instruct users that they can enter multiple values by using "," as a separator and no spaces.
3) create a new query, using Text.Split(parameter_name, ",")
4) Filter the name column equals new query column.

let
    Source = Excel.Workbook(File.Contents("\\xxxxx\test_xls\test.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"name", type text}, {"value", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Split(Parameter1,",")),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Custom", each ([name] = [Custom])),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Custom"})
in
    #"Removed Columns"

[Anonymous]

Please Help,

How can I pass these parameter into publish dashboard in Power BI

[Anonymous]

I am trying to find that manage parameter text field in power BI desktop application version 2.99.621.0 but did not able to locate can you please help me on it

[Anonymous]

The problem is in multi select slicer, if I have to select more than 10 options, it would become difficult.. I basically intent to filter a phone number based report where I want to filter things for more than 100 numbers at once. And hence ask for delimted input variable.

[Anonymous]

Is there some hope on this one ?The problem is in multi select slicer, if I have to select more than 10 options, it would become difficult.. I basically intent to filter a phone number based report where I want to filter things for more than 100 numbers at once. And hence ask for delimted input variable.

[amitchandak]

@Anonymous , I doubt an option like that. Because you have split values and create an in clause that is not going to easily in DAX. Better to use multi-select slicer