Forum Discussion

adegokeopeoluwa's avatar
adegokeopeoluwa
Frequent Visitor
3 years ago

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

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