Forum Discussion
SachinC
Helper V
10 years agoDefaulting Time Slicers to Today
Hi, I have a report with slicers for Month, Day etc... How can I default the values to Today, i.e. 12/07/2016? Thanks, S
kdejonge
Microsoft Employee
10 years agoWhat I usually do is create a new calc column in the date table that does something like this:
Column = IF([Date] = TODAY(), "Y", "N")
then you can use this a slicer.
Now schedule refresh every night, the column will then automatically updated to the new day on nightly basis.