Pass Slicer Value to SQL Statement Using Direct Query

[datatravis]

Hi All!

Is it possible to pass values from slicers into the SQL statement.  I have logic in my SQL statment that I would like to keep but I need the ability to pass in filter values for the query to return the correct results. I know you can create parameters but those do not tie into slicer values. I have also tried creaiting measures and modifying the m query. 

Any help or guidance is greatly appreciated. 

[v-juanli-msft]

Hi

As tested, I'm afraid it is not possible to pass values from slicers into the SQL statement.

Best Regards

Maggie