Forum Discussion

FilippoV's avatar
FilippoV
Icon for Helper I rankHelper I
8 years ago

Data Slicer - Filter Date Range

Hi Community, i'm looking for a slicer that allow the user to filter a date range, example: From 01/01/2017 to 09/10/2017 and from 01/01/2016 to 10/10/2016.   I use "Date Hierarchy" but this cust...
Need Help
Tips and Tricks
miltenburger's avatar
miltenburger
Icon for Helper V rankHelper V
8 years ago

Np FilippoV

In this slicer it's not possible to select 2 date ranges (didn't understand that's what you wanted)

Sounds really stupid, but you have te make two slicers as far as my knowledge goes.

So if you need two date ranges make 2 time slicers (it's not a nice method if you need more then 2 ranges, because you need more slicers....)

 

Hope it helps you?

FilippoV's avatar
FilippoV
Icon for Helper I rankHelper I
8 years ago

thanks miltenburger but in my case the user want select over 2 years.

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi FilippoV,

     

    Per my knowledge, users are not allowed to select two or more date ranges in a single slicer. I'm afraid your requirement cannot be achieved currently.

     

    If the data ranges selected for each year are all the same, maybe you can create three slicers to display Year, Month and Day separately.

     

    Regards,
    Yuliana Gu