Forum Discussion
How to pass Dynamic M Query Parameter into Slicer (Text)
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.
Thanks for clarifying this. Makes sense that free-text entry isn’t supported natively with Dynamic M Query Parameters, and I’ll explore the custom visuals route for this requirement. Appreciate the suggestion about using a lookup/disconnected table as well—good to know the supported alternatives.
Hi prabavathym,
Glad to hear the clarification helped and that the alternatives make sense. Yes, currently free text entry is not supported directly with Dynamic M Query Parameters, so exploring custom visuals is a good next step.
If you decide to try that approach and run into any challenges with setup or functionality, feel free to share the details here we will be happy to help further.
Thanks again for updating the thread, and good luck with the custom visuals route.Thank you
Hi prabavathym,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.