Forum Discussion
How to pass Dynamic M Query Parameter into Slicer (Text)
Hi prabavathym,
Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.
Thank you.
Thank you again for checking in and for your kind support . I tried the suggested solution, and I also explored using custom visuals — but unfortunately, I’m still not able to make the parameter typable in Power BI. Right now it only works as a dropdown or predefined list.
Thanks once again for your patience and guidance.
Hi prabavathym,
Thank you for your update, and I really appreciate your patience while testing the suggestions.
Currently, in Power BI, parameters are limited to dropdown or predefined lists free text/typable parameter input is not supported natively. This is why you are only able to select values but not type them directly. As possible workarounds, you might consider.Using a What-If parameter combined with a slicer this gives predefined ranges but still allows some flexibility.
Creating a disconnected table that users can interact with (e.g., entering values via Excel or SharePoint list) and then binding that input to your model logic.
Also, kindly refer these links:
1. https://learn.microsoft.com/en-in/power-bi/transform-model/desktop-what-if
2. https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters#considerations-and-limitationsAlso, please refer this solved thread which is helpful to you:
https://community.fabric.microsoft.com/t5/Service/List-parameters-m-query-not-shown-as-drop-down-in-Power-BI/m-p/1025631If free-text input is critical to your scenario, I would recommend submitting an idea or upvoting similar ones on the Power BI Ideas forum Fabric Ideas - Microsoft Fabric Community
So This way the product team can consider adding it as a feature in the future.Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
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.