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
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