Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |