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