Can you use Power Query Dynamic M Parameters for multi-select?

Dynamic M parameters in Power Query isn't anything new. However, Patrick was challenged with using them to allow for multi-select and "select all" with a slicer in a Power BI report. Will he succeed?

Dynamic M query parameters in Power BI Desktop


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #PowerQuery #GuyInACube

[pravin_]

Hey Patric,
Performance wise it is bit slow since you are loading data first then filtering it out. I would suggest you to pass the parameter directly in where clause.

[vish]

This is great! I had to watch this to prepare for the power bi pl-300 exam. Maybe you guys can make a video on how to prepare for it??

[andersonrivera]

This is the most powerfull video eveeeer! It saved my life! thanks a lot!

[vijaykommaraju]

Great Video! In this technique, is the country filter applied after all the data is pulled into the dashboard or, are the filters passes to the underlying source and only required data is fetched?

[dcmurbk]

This is great thank you so much !, does anyone have an extended example of using say 4 slicers in combination using this method ?

[premjitchowdhury]

Hi Patrick
Love your videos from India

[randychen]

quick question, when will we need it? Cuz seems it's similar to the slicers. Please advise. Thanks

[prarabdhachaturvedi]

Hey Patric,
this Binding Parameter option is only available in Directquery Mode,
can we do something like this in Import Method?

[vidyashreerayar]

is there a way to make the 'edit parameter' feature available for the users in power bi service. any insights are much appreciated

[MikeHaynes-xdmw]

Hey Patrick, how would you do this using import with a stored procedure.

[antonindelbart]

Hey Patrick,

With DirectLake mode, Dynamic M Parameters does work ?

[ghamper]

Q: Hey Patrick, I use a lot of MDX in dataflows to query our multi-dimension database, is it possible to pass through dynamic parameters into my select statement? Ex. Choose a month in the dataflow and it update my code. Thanks!!

[alexissourceau]

Q: Great video as usual, thanks ! How can we do if we want to pass any values instead of a multi select slicer to do like a « what-if parameter » using Direct Query ? Chris Webb has written a great post about it on January 2023 but my business users are not very fan of using the « Filter by List » visual, they would like to use a slicer as a what-if parameter…

[tatsianastarastsenka]

Hi,
thank you for the video. It's great! Have you tried multi-select for parameters of date type?

[BISimplifier]

good one,
But why we need to use dynamic M, instead simple slicer ?

[zintuplet]

Can you do it in a SQL Direct Query? I needed to do this using Report Builder which couldn't connect directly to databricks, so I had to create the dataset in Power BI with M-parameters.

[aaronziebart]

Somehow adding the multiselect code in, my headers were eliminated. Do you know how to fix this?

[paulolujan]

can this be achieved in Excel? ...using powerquery of course. Thank you.

[sumksa]

Can you do it with date parameter? I am not getting all the dates present in my power query in power bi. Any suggestion?

[azeemalishaik]

what was the parameter type ? is it any or text ?