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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
Microsoft Employee
Microsoft 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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