Relative date slicer depending on date chosen in another slicer

[PBIUser12]

Hi,

I use a relative date-filter in my report, which shows the last 10 weeks from now:

But I also have two other slicers based on years and weeks, which filter some other visuals:

The relative date slicer always counts x weeks from now (last week, 51), not depending on what week is chosen on the other slicers:

Does anyone of you know, how I can combine these slicers (e.g. If I choose week 46, the relative slicer goes 10 weeks back from week 46)?

I've tried to solve it via the visual interaction, but unfortunately it didn't work.

Thanks a lot!

[v-yanjiang-msft]

Hi @PBIUser12 ,

Has @amitchandak 's solution solved your problem? If yes, please kindly accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

[amitchandak · Accepted solution]

@PBIUser12 , You can not. You have to build using date slicer and custom slicer and custom measure

refer example

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[PBIUser12]

Ok, thank you! 🙂