Dropdown Slicer Without Date Hierarchy

[GJeanes1]

So I am trying to have multiple variables on 1 dropdown slicer. 
I have tables with DAX codes to separate the last 7 days, 28 days, and 2023 year-to-date. 

Last 7 Days Column = IF('Sheet1'[Date] > TODAY() - 7 && 'Sheet1'[Date]<= TODAY(), "Last 7 days", BLANK())

However, my data right now includes information from 2019-2023 all in a single "year" column. 

So essentially I would like to have a slicer read: "last 7 days", "last 28 days", "2023 year-to-date", "2022", "2021", "2020", and "2019".

Let me know if there is anything else that I could provide that would be useful.

[v-binbinyu-msft]

Hi @GJeanes1 ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[GJeanes1]

Sure, so here is an example of what I am trying to accomplish

and here is my excel sheet that I am working with, On my PBI data, I have columns with the measures for last 7 days, last 28 days, and one with 2023 "year to date".