Capturing the selected Slicer (date between) for direct query use

[adegokeopeoluwa]

Description: I am creating a report In which I need to make different counts and sum of rolls based on the slicer dates selected by the user.

In the visual, I am using the slicer's date between option to reduce the number of rows. The slicer is using a date. I also created different queries to extract the data from the database. I created two parameters used in the where clauses to get rolls between the dates provided. 

Issue: I do not know how to pass the selected two dates value to my two parameters. 

I plan to capture the slicer date A and B separately, bind them to parameters Y and Z. Then use Y and Z in the queries where clauses to extract the data set that falls in-between Y and Z for each of the queries. 

Appreciate it if you provide some guidance on this issue   

[AntrikshSharma]

@adegokeopeoluwa Please read this: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters