Forum Discussion

jd8766's avatar
jd8766
Icon for Helper II rankHelper II
4 years ago
Solved

PBI Date Slider - shows all dates in date table when selecting first/last dates between period

Hi, I have a date field from my calendar table used as a slider. The slider has a filter on it to only allow the previous 2 years to be selected. However if you move the slider selection to the first...
  • v-luwang-msft's avatar
    4 years ago

    Hi jd8766 ,

    This behavior is by design. There are 2 aspects collaborating together:

     

    1. The relative date filter applies only to the values that are selectable in the slicer. That filter won't propagate anywhere else.

     

    2. A behavior of the range slicer is that if the customer does not move the slider at both ends, as shown in the figure below, there is effectively no filter applied.

     

     

     

    So if you never changed the ends of the range, either by dragging the slider or typing in a value, or if you selected the values that are the Min or Max, the filter won't do anything in actuality. This is to allow scenarios where one of the ends keeps changing.

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien