Forum Discussion

EVEAdmin's avatar
EVEAdmin
Icon for Post Patron rankPost Patron
3 years ago

Automatic Update Date Slicer to Today

Hi all
on many reports, I use a slicer to select dates, as in the screen shot below.

The slicer style is set to "Between".
On some reports, the 2nd date will automatically display today's date, when I open the file.

On other reports, the 2nd date will not automatically display today's date.

I can't figure out the difference. 

Any idea, please?

 

 

Need Help

3 Replies

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

    EVEAdmin , You need to use a workaround

    Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

     

     

    new columns, needed in date table

    Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")
    Is Last 30 = if('Date'[Date]>=TODAY()-30 && 'Date'[Date]<=TODAY(),"Today",[Date]&"")

    Is Last 90 = if('Date'[Date]>=TODAY()-90 && 'Date'[Date]<=TODAY(),"Last 90 Days",[Date]&"")

     

     

     

    • EVEAdmin's avatar
      EVEAdmin
      Icon for Post Patron rankPost Patron
      3 years ago

      amitchandak thank you, appreciated.
      I added this column to my Calendar table:

      Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

       

      However, when I add the column to the slicer, then I loose the option "Between dates", in the formatting pane. And I need to be able to select any random date range.