Creating drop down slicer to filter for day, week, month, previous day

[theglamcoder]

I am having difficulty creating a drop down slicer that will filter for day, week, month and previous year. I have researched but haven't found a solution. Is it possible to have all this in 1 drop down slicer?

This is what I created so far:

[v-chenwuz-msft · Accepted solution]

Hi @theglamcoder ,

Is that you want something like this:

If yes, you need create two columns first via 

Yeartype = IF([Date].[Year] = year(TODAY()),"this year","previous year")

and

Week = WEEKNUM([Date])

If not, please share what you want by hand-drawn.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.