Binding Dynamic M query parameter

[ganotra_2730]

I have created the dynamic m query parameter for routeno and binded to routeno present in my routehistory table  but in slicer I want to use the route name column present in my routehistory table like changing any route name in slicer also change and update M query routeno parameter value

[lbendlin]

ok, what is your question?

[ganotra_2730]

How can I implement the above as dynamic binding is not working when I am changing the value in my slicer

[lbendlin]

As long as th route name and route number are in the same table and both are unique  this should work as is.

[ganotra_2730]

Thanks for your reply but its not working when changing the value in the slicer as I think value of Routeno M query parameter is not changing dynamically when selecting any routename in the slicer

[lbendlin]

Since this is a Direct Query data source it will be difficult to reproduce.  Let me do some tests.