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

[jd8766]

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?

[v-luwang-msft · Accepted solution]

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

[Hariharan_R]

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

[jd8766]

still the same issue