Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi is it possible to pass slicer value selected by end user to power query? i dont want to load full list of data as it seems to be huge
Solved! Go to Solution.
Hi @jinuelsa ,
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
Hi @jinuelsa ,
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
@jinuelsa , 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/
Hi 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
unfortunely not!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |