Passing parameter via slicer

[DIMBACKA]

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

[amitchandak · Accepted solution]

@DIMBACKA , Dynamic M parameters can help in direct query

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters