Custom Time Periods in a slicer

[PaulTrower]

Hi,

I'm trying to display what people are working on over different time periods i.e. show me what each person is working on over the next four weeks or 12 weeks or all time or the previous four weeks etc.

I'd like to end up with a slicer similar to the image below.

I've tried to think around the problem but the complication for me is that the categories overlap (Next Twelve Weeks would naturall include the Next Four Weeks for example).

How best should I structure my data so that I can achieve the outcome that I would like?

Just to give you a heads up this is what I've started with, this is a column that indicates if the week commencing is in the next four weeks. I then created a similar column for the NextTwelveWeeks but I wasn't then sure if this is the best method - or quite how to finish things off because the slicer then looked like this and I can't understand why.

NextFourWeeks = If ('Date Table'[ResourceYear] = 'Date Table'[CurrentYear] && 'Date Table'[ResourceWeekNumber] <= 'Date Table'[CurrentWeekNumber]+3 && 'Date Table'[ResourceWeekNumber] >= 'Date Table'[CurrentWeekNumber],"4","Not 4")