Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
Hi @QiZhengXu ,
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!!
Hi @QiZhengXu ,
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!!
Thank you for providing the solution, it is indeed a way to solve this problem.