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 or last date on the slider... it shows everything.. and my visuals end up looking like the below


Any idea what is causing this and how to fix?

 

Need Help
Show and Tell
  • v-luwang-msft's avatar
    v-luwang-msft
    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

3 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi

    If you set the visual filter for that slicer then you should see only those date not before that. Please check below.

     

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    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