Forum Discussion
power bi pass slicer value as query parameter
Hi Anonymous ,
Slicer works on visual level, it will not filter the underlying data. You could create a query parameter and use it to filter data when you loading data.
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
Best Regards,
Jay
Super UserAnonymous , Check if Dynamic M parameter can help
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
or
https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/
Helper IHi Amit,
Dynamic M paramater work only when we use direct query. We have source data as power bi dataset.
Exceptation is the paramater set in power query need to be added in slicer and shown to user to select it power bi service, or in anyway end user who as only viewer access should be able to change the values of paramater. please advise
