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...
Thank you for the suggestions.
I will try to be more specific:
- I am using DirectQuery mode, so Power Query Editor functionalities are limited and to split columns I have to use measures or new columns in the Tables/Visual Editor (with already extracted data)
- as shown here, the values P and D are in the same column, but one for row. So, I need to create a parameter (i.e.: param = "P";"D") able to filter all the rows of the table. In details, the parameter by default will select all the rows (imported via DirectQuery with Advanced Editor), but the user could select a single value if needed ("P" or "D" only)
Let me know if you need additional details.
Kind regards for your help,
Aris Dressino
You posted in the Power Query section of the forum hence we assumed it was a Power Query question.
In DAX you can use the PATH() functions. Before you can do that you will want to replace ";" with "|".