Forum Discussion
Slicer issue - Date slicer issue
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
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!!
2 Replies
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!!