topic Re: Slicer issue - Date slicer issue in Report Server

Slicer issue - Date slicer issue

Anonymous — Wed, 12 Mar 2025 10:05:28 GMT

Hi Power Bi community,

I encountered an issue related to dates while using slicers.

When I add the same date data into two slicers, I allow the Date1 slicer to filter the Date2 slicer.

In the default state, when I change the range of the Date1 slicer, the default range of the Date2 slicer also changes accordingly.

However, if I have already modified the Date2 slicer's range, for example, selecting the time range from 2024/7/1 to 2025/3/11 in Date2, even if I reduce the time range of Date1 to 2024/8/1, the Date2 slicer's range does not change.

In fact, with Date2, the time period 2024/7/1 to 2024/8/1 is still selectable.

However, when I select any date within this range, the earlier dates become grayed out and unselectable.

Is this a bug? If not, could you please advise how I can resolve this issue and ensure that the selectable range of Date2 always aligns with the range selected in Date1?
Thanks for any suggestions

Re: Slicer issue - Date slicer issue

AthmakuriRekha — Wed, 12 Mar 2025 11:02:49 GMT

Hi Anonymous ,

While trying to apply filter from Date 2 Slicer, Click on Clear Filter Selection Button on Date Filter 1 and 2.

Filtered Date 1 and Date 2 Filters using Date 1 Slicer.

Clearing the filters for both the slicers.

Filter Using Date 2 Filter.

Hope this answers you question.

Thanks!!

Re: Slicer issue - Date slicer issue

Anonymous — Tue, 18 Mar 2025 01:36:03 GMT

Thank you for providing the solution, it is indeed a way to solve this problem.