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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Minakshi
Resolver I
Resolver I

date slicer is not updating using week slicer

Hello Experts,

I have 2 slicers in my report
1. Date Slicer
2. Week Slicer
I want week slicer to change my date slicer but week slicer is not able to filter date range.
Kindly help me, how can I implement it?
Thanks in Advance

w28, 29 filterw28, 29 filterW28 filterW28 filterno filterno filter

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Select one, and hit Edit Interactions. I believe by default they don't filter each other.. make sure you enable filter of one to the other. 

View solution in original post

8 REPLIES 8
Minakshi
Resolver I
Resolver I

@Anonymous, @Anonymous  if I make list of dates they are getting filtered but when I use range , it doesn't filter. Any suggestion will be helpful.

Anonymous
Not applicable

@Minakshi sorry, I don't think I have an answer for you. I have a very similar date table setup, and I can drive the date value with a week filter whether it's a list or a range as long as my interactions are set correctly. 

Anonymous
Not applicable

Select one, and hit Edit Interactions. I believe by default they don't filter each other.. make sure you enable filter of one to the other. 

@AnonymousThank you so much for your suggetion but already checked that.

Anonymous
Not applicable

@Minakshi  Are both your date and week slicers from the Date table?

@Anonymousyes, they are from same table date table.

Anonymous
Not applicable

Can you share how your data model is setup?

@Anonymousmy data model and date table looks something like this.Date TableDate TableModelModel
Thanks for quick response

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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