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, wh...
Need Help
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.