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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.