Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

To create a Date Slicer

I wanted to create  a date slicer of Today, last 2 days ,this week and this month can anybody pls explain And the slicer order should be in   Today   Last 2 days   this week and  this month ...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    1. first use enter data to create a new table like:

    2. then please new a measure like:

     

    Measure = 
VAR _SLICER = MAX('Table'[Slicer])
VAR _TODAY = TODAY()
VAR _DATE = MAX('Calendar'[Date])
VAR _LAST_2_DAYS = TODAY() - 2
VAR _FIRSTDATEOFWEEK = TODAY() - WEEKDAY(TODAY(),2)
VAR _MONTH = MONTH(_TODAY)
VAR _YEAR = YEAR(_TODAY)
VAR _FILTER = 
SWITCH(
    TRUE(),
    _SLICER = "Today"&&_DATE=_TODAY,1,
    _SLICER = "Last 2 days"&&_DATE>=_LAST_2_DAYS&&_DATE<_TODAY,1,
    _SLICER = "This week"&&_DATE>=_FIRSTDATEOFWEEK&&_DATE<_FIRSTDATEOFWEEK+7,1,
    _SLICER = "This month"&&_YEAR=YEAR(_DATE)&&_MONTH=MONTH(_DATE),1
)   
RETURN
_FILTER

     

    3. apply it to the filter:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Best Regards,
    Gao
    Community Support Team

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous  I did the exact same thing but it didnt show in order

can you pls tell me where did i miss

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Best Regards,
Gao
Community Support Team

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you so much Anonymous 
    and i would like include  date picker also such as:

      Today
      Last 2 days
      this week 
      this month 

    is working perfectly fine ...

     

    is there anyway that we could include Custom(Date picker) in the same slicer ?

     

    Thanks in Advance !!!

     Anonymous @Eyelyn9 @BI @andres777 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hii Anonymous
        

      Is it possible to include custom(date picker) in the same slicer


       amitchandak Greg_Deckler Shaurya BI 

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous ,

        Do you mean adding another such slicer to the inside? Unfortunately, this is not possible at the moment.😥

         

        Best Regards,
        Gao
        Community Support Team