Forum Discussion

GJeanes1's avatar
GJeanes1
Frequent Visitor
3 years ago

Dropdown Slicer Without Date Hierarchy

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.

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      GJeanes1
      Frequent Visitor
      3 years ago

      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".