Dynamic Date filter

[sam021083]

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

[v-yuezhe-msft · Accepted solution]

@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

[sam021083]

@v-yuezhe-msft Thank you. It worked exactly as needed.