Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Slicer calendar problem

Hello everyone,

 

My question is this. I have data since 1956. I need to use the cutter on two dates, "First date" and "Last date", but the slicer only show10 years in the future or in the past.

I have used the filters page but I would prefer another solution. It is not easy for users to manage four dates.

 

Any idea?

Thanks

 

 

 

 

 

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Anonymous,

     

    I'm a little confused about your scenario.

     

    What do you want to achieve for Slicer? 

     

    If it is convenient, please share your desired output so that I can understand your requirement better and get the solution.

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      Thank you I would like to be able to choose the dates from January 1, 1956 until today, any period between those dates, and with that slicer I can not do it.

       

      Now I am using the page level filter, but the report has two periods of time, "first day" and "last day", and the user can choose any period of time in both fields, and the page level filter is a bit confusing for the user

       

      Another way to do it.

      I was testing with Dax and asking for other ideas or some way to change the behavior of the filter