Forum Discussion
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
1 Reply
- AntrikshSharmaCommunity Champion