Forum Discussion

sam021083's avatar
sam021083
Frequent Visitor
8 years ago
Solved

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

 

 

  • Anonymous's avatar
    Anonymous
    8 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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      sam021083
      Frequent Visitor

      Anonymous Thank you. It worked exactly as needed.