This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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 @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!!
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!!
Thank you for providing the solution, it is indeed a way to solve this problem.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |