Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SachinC
Helper V
Helper V

Defaulting 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

4 REPLIES 4
KHorseman
Community Champion
Community Champion

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi,

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

Thanks!

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




kdejonge
Employee
Employee

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.