Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |