Forum Discussion
Passing parameter via slicer
Hi community,
Hoping you can help me out.
Not sure if this is possible.
I have a report, which has a slicer. My goal is to pass the slicer value to the underlying query, so that the query is automatically regenerated. Basically: pass a slicer value as a parameter to the underlying query.
The slicer value is set from 0 to 100, and this value is then used against an API to get the respective relevant data for the report.
I know this is possible in DirectQuery mode, but this report is currently in Import mode.
Anyone can point me to the golden hint?
FilipVDR FYI
DIMBACKA , Dynamic M parameters can help in direct query
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
1 Reply
- amitchandakSuper User
DIMBACKA , Dynamic M parameters can help in direct query
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters