Forum Discussion
Helper IIHow to pass Dynamic M Query Parameter into Slicer (Text)
Super UserJust try to use the Parameter in slicer, isn't that simple?
Helper IINo 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)
- srlabhe
Use the field in slicer where you binded your parameter to
- prabavathym
Thanks for the suggestion!
I did try using the field that I bound my Dynamic M Query Parameter to in a slicer, but since it’s just an empty column, it doesn’t provide any values to work with. What I’m really looking for is a way for the end-user to manually type or enter a value in the report (like a text input box), and then have that value passed directly into the parameter at query time.
From what I understand, normal slicers only work with predefined values in the model, but in this case I’d like it to work dynamically without having to populate the column with static values.
Has anyone managed to simulate this kind of “text input slicer” for Dynamic M Query Parameters? Or is there a workaround ?