Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.: worker_param = p;d). Is it possible to achieve the same result in Power Bi?
In details, the table contains a column with values p or d and I would like to have worker_param taking both p and d as default values, but the user could filter the single value if needed. Let me know if you need additional details!
Kind regards,
Thank you for the suggestions.
I will try to be more specific:
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 "|".
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
Hi, @Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may go to 'Query Editor', click 'Manage Parameters' to create a parameter as below.
Then you may right-click 'Changed Type' to create a new step as below.
Custom1 = Table.ReplaceValue(#"Changed Type",each [Column1],each Parameter1,Replacer.ReplaceText,{"Column1"})
Finally you may change the parameter to modify the value in 'Column1'.
For further information, please refer to the following links.
Deep Dive into Query Parameters and Power BI Templates
Power BI Desktop Query Parameters
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
in Power Query, split the column by delimiter and in the advanced option select "split into rows"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.