Forum Discussion
assign multiple values to single parameter
Good morning, we are trying to move some reports from an old software to Power BI with DirectQuery... The old software gives the possibility to use multiple values in a single parameter (i.e.: wo...
Hi Ari,
What you're asking for is certainly possible, but requires some extra steps.
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 anything you want using List.Contains(#"new query", Value)
Regards,
Spyros
What you're asking for is certainly possible, but requires some extra steps.
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 anything you want using List.Contains(#"new query", Value)
Regards,
Spyros
to have a more adherent answer to your needs, you should illustrate in more detail the context in which to apply this "feature"
but for the momento, here it is an idea ..
let fnChoice=(optional inp)=> let par=[p="p",d="d"], out=if inp= null then Record.FieldNames(par) else inp in out in fnChoice