Forum Discussion
How to pass Dynamic M Query Parameter into Slicer (Text)
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-limitations
Also, 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/1025631
If 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.