Forum Discussion

cv2qm's avatar
cv2qm
Icon for Helper I rankHelper I
6 years ago
Solved

Set default Today in Slicer date and also select date

Hello community,

 

I am implementing a date picker in slicer. I achived that by using 'before' option in slicer, and wrote DAX measure to bring selected date related value. 

Calender table has dates from 2018 to 2023. 

I want to set slicer Date to Today. How can i do this?

Don't want to use relative Date option. 

 

 
 

Below Dax measure I am using to bring selected date event. That works fine.  

 

 

Selected day Event = 
Var selectedate = MAX('Calender Table'[Date])
return 
CALCULATE(MIN(Data[Event Name]),TREATAS({selectedate},'Calender Table'[Date]))

 

 

Any suggestions please. 

 

Thanks !

Need Help
Tips and Tricks

7 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago
    You can only use the built in relative date filters on the slicer, so if you are using 'before' you cannot set it to always be today. Do you ever need it to show future dates? You could add a filter to the slicer to only show dates in the past 3? 10? years so that it only goes until today?
    • cv2qm's avatar
      cv2qm
      Icon for Helper I rankHelper I
      6 years ago

      I just want to show today's date in sllicer always, if i can use relative date in filters how can i set slicer today's date always. 

      User can pick any date from Slicer.

       

      Thanks! 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        cv2qm 

         

        Power bi doesn't support set default option in a slicer. However, there is a workaround that is possible by creating a measure to show today()'s data when nothing selected in the slicer, meanwhile you can select other dates in the slicer, please see the attached pbix.

         

        Paul Zheng _ Community Support Team
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    cv2qm , there is way initialize on a function like today. 

    You can have a column like this in you date table sorted on date and use that to filter today

     

    Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
    ,'Date'[Date]=TODAY()-1,"Yesterday"
    ,'Date'[Date]=TODAY()-2,"2 Days Ago"
    ,'Date'[Date]&"")

     

    In case you need more than a day data when you select only today -

    https://www.youtube.com/watch?v=duMSovyosXE

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    cv2qm 

    You can create another column in the calendar table to get the date from the beginning to today. Then use 'Before' option in the slicer.

    Date-Today = IF([Date]<=TODAY(),[Date])

     

     


    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.