Forum Discussion
How to pass Dynamic M Query Parameter into Slicer (Text)
Hi all,
I’m working with Dynamic M Query Parameters in Power BI. I’ve created a parameter called Product (screenshot attached). The setup works fine, and I’m able to see the Edit Parameters dialog.
Now, I want to bind this parameter to a text slicer so that users can type a value it the slicer, and it should pass that value into my parameter.
I’ve already:
Created the parameter in Power Query
Configured it as a Dynamic M Query Parameter
Bound it to an empty column
i would like to pass this as text slicer.
i would like to pass this as text slicer.
Is there any way in which we are able to pass this value inside our dashboard using slicer. Because everytime we will not able to open transform data - edit parameter- then changing the value and click ok(I dont think this as an efficient way).This method will lead an issue in powerbi service also.
So i want smthing inside my dashboard similar to text slicer. I need to pass the value using that text slicer.
Has anyone implemented this before?
Thanks in advance
16 Replies
Just try to use the Parameter in slicer, isn't that simple?
No it doesn't pass into text slicer. If i pass this into an dropdown slicer also it will be empty as it dont have values in it, (its not normal parameter, its dynamic m query parameter)
Use the field in slicer where you binded your parameter to
Hi prabavathym,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to srlabhe, for his inputs on this thread.
The behaviour you are seeing is expected because Dynamic M Query Parameters cannot be entered directly through the Edit Parameters dialog in a report. By design, they need to be bound to a field in your model so that end users can interact with them via a slicer or filter inside the dashboard. To make this work perfectly, do those steps in below mentioned.
Create a disconnected table with your possible parameter values. Bind your Dynamic M Query Parameter to that column. Add a slicer visual from that column, so users can pick the value directly in the report.If you want true free-text entry (instead of pre-defined values), Power BI does not have a native “text slicer” now, in that case you can look at custom visuals like Smart Filter Pro from AppSource.
Refer this link for more information: https://learn.microsoft.com/en-in/power-bi/connect-data/desktop-dynamic-m-query-parametersHope this helps. If you have any doubts regarding this, please feel free to ask here. We will be happy to help.
Thank you for using the Microsoft Community Forum.Thank for your reply.
I also tried this method : Create a disconnected table with possible parameter values. Binded the Dynamic M Query Parameter to that column. Added a slicer visual from that column, so users can pick the value directly in the report.But client was looking for texting related visuals. Let me try with that custom visuals.
Hi prabavathym,
Thanks for getting back and sharing the additional details. You are right, Dynamic M Query Parameters work best when bound to a slicer or dropdown for user selection. At this point, there is not a built-in way to directly bind them to free-text inputs or “texting-style” visuals in Power BI.If the client specifically needs a text-entry experience, the best approach would indeed be to look into custom visuals that support text input. Another option is to provide a pre-populated lookup/disconnected table with possible values (as you already tried) and allow users to select from there, which is currently the supported method.
Hope this helps. If you have any doubts regarding this, please feel free to ask here. We will be happy to help.
Thank you for using the Microsoft Community Forum.
