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,
May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.