Forum Discussion
sam021083
8 years agoFrequent Visitor
Dynamic Date filter
Hi All,
I have a date column in my table with name 'Report Date' which I am using in a slicer to display the detail data in a table according to the date selected in the slicer.
But as per the requirement, if a user selects a date from slicer like '4/27/2018', the detail data should be displayed from '4/27/2018' to till date and if '4/23/2018' is selected the detail data should be displayed from '4/23/2018' to till date.
Any help is greatly appreciated.
Thanks,
Sam
- Anonymous8 years ago
sam021083,
You can create a slicer using your date field, choose After in the date slicer, and select different dates as start date in the slicer to filter your visual.
Regards,
Lydia