Use slicer values as parameter

Question

I have a calculated table where I want to use a value from a slicer as a parameter for filtering. Is that possible? There is no visual based on that calc table.&nbsp;Thanks

greg_deckler · Answer

Markzolotoy&nbsp;Are you talking about this:&nbsp;Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs?
&nbsp;
Otherwise, I don't understand the question.

markzolotoy · Answer

Can that be applied to a calculated table and the table would be saved back to the dataset?

greg_deckler · Answer

Markzolotoy&nbsp;Not sure I understand the question.

markzolotoy · Answer

What I mean is that calculated table is stored in the dataset and can be accessed in paginated reports. I am thinking how I can provide data to the paginated report that it doesn't have to filter data on user selections since the data is already been filtered on these in the PB Desktop.

v-lianl-msft · Answer

Impossible, the calculated table is static, and the slicer can change dynamically.

Forum Discussion

Use slicer values as parameter

5 Replies

Related content

Make a field parameter slicer that adjusts according to another field parameter's selected value

TDS Endpoint multi value parameter PBRS

power bi pass slicer value as query parameter

Slicer-Bound Parameter DirectQuery

Problem with field parameter and empty slicer