Defaulting Time Slicers to Today

[SachinC]

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

[KHorseman]

I assume this is all taking place in a standard date table? Make a calculated column to use as a slicer.

Selected Day = IF(DateTable[Date] = TODAY(), "Today", FORMAT(DateTable[Date], "dd/MM/YYYY"))

Add that column as a slicer on your report, select Today on the slicer and save.

[SachinC]

Hi,

It could be Quarter, i.e. Q3, Week, i.e. 15, Day, i.e. 7 etc... 

Thanks!

[KHorseman]

I don't understand what you're asking for. Do you not want a slicer that allows you to select single days that defaults to today's date?

[kdejonge]

What 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.