The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
ok, what is your question?
How can I implement the above as dynamic binding is not working when I am changing the value in my slicer
As long as th route name and route number are in the same table and both are unique this should work as is.
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
Since this is a Direct Query data source it will be difficult to reproduce. Let me do some tests.