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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Year slicer not filtering the date range slicer

I have a year slicer with year value like 2020,2021 and 2022

and another date range slicer with value from 1-1-2020 to 8-31-2022

 

 If I select year slicer and select value like 2020 than date range slicer should filter the date according to year 2020 only -but it's not working,  whereas if I put the date range slicer in dropdown or list date slicer - the Year is filtering correctly but for the range it's not working.

 

Any suggestion would be appreciated.

 

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@amitchandak 

I got the solution - usually when you slice/filter from the Year slicer to date range slicer, bydefault edit interaction was set none so we have to make it filter(edit interaction) and it will work. 🙂

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , Range base slicers usually do not get filtered by other slicers. You can create and idea -https://ideas.powerbi.com/ideas/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak

That's what I was thinking - Thanks for your input and sure I will put this under Power BI create idea.

Anonymous
Not applicable

@amitchandak 

I got the solution - usually when you slice/filter from the Year slicer to date range slicer, bydefault edit interaction was set none so we have to make it filter(edit interaction) and it will work. 🙂

Does not work for me

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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