Forum Discussion
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 table (Ex: select * from table for system_time as of '2025-09-01').
Is that possible?
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
5 Replies
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
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.
Hi sboivin2,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
