Forum Discussion
Solved
Can I dynamically refresh a table from a value that the user has chosen on a slicer?
I have a slicer where I want the user to chose a value (Ex: 2025 Fall) and I have a reference table that should return then a date value (Ex: 2025-09-01) that I want to pass in a query in a temporal ...
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Your source table (the one feeding the slicer) should be in import mode.
The data table must be in Direct Query mode.
Yes, you just need to use a cube formula to pick up the value that is selected from the slicer. Use that value as a variable by using "Get Data" from worksheet.
--Nate
Hi sboivin2,
Could you please confirm if your query have been resolved the solution provided by lbendlin & nathancwatkins ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you