Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
QiZhengXu
Microsoft Employee
Microsoft Employee

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.

QiZhengXu_0-1741773605177.png

In the default state, when I change the range of the Date1 slicer, the default range of the Date2 slicer also changes accordingly.

QiZhengXu_1-1741773643779.png

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.

QiZhengXu_2-1741773697416.png

 

In fact, with Date2, the time period 2024/7/1 to 2024/8/1 is still selectable.

QiZhengXu_3-1741773727571.png

 

However, when I select any date within this range, the earlier dates become grayed out and unselectable.

QiZhengXu_4-1741773746409.png

 

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

1 ACCEPTED SOLUTION
AthmakuriRekha
Frequent Visitor

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.

AthmakuriRekha_1-1741777199196.png

Clearing the filters for both the slicers.

AthmakuriRekha_2-1741777249297.png

Filter Using Date 2 Filter.

AthmakuriRekha_3-1741777309422.png

Hope this answers you question.

Thanks!!

 

View solution in original post

2 REPLIES 2
AthmakuriRekha
Frequent Visitor

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.

AthmakuriRekha_1-1741777199196.png

Clearing the filters for both the slicers.

AthmakuriRekha_2-1741777249297.png

Filter Using Date 2 Filter.

AthmakuriRekha_3-1741777309422.png

Hope this answers you question.

Thanks!!

 

Thank you for providing the solution, it is indeed a way to solve this problem.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.