Can I dynamically refresh a table from a value that the user has chosen on a slicer?

[sboivin2]

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?

[lbendlin · Accepted solution]

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.

[v-ssriganesh]

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.

[v-ssriganesh]

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.

[v-ssriganesh]

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

[nathancwatkins · Accepted solution]

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

[lbendlin · Accepted solution]

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.