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
EVEAdmin
Helper V
Helper V

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, when I open the file.

On other reports, the 2nd date will not automatically display today's date.

I can't figure out the difference. 

Any idea, please?

 

EVEAdmin_0-1673867785382.png

 

3 REPLIES 3
amitchandak
Super User
Super User

@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]&"")

 

 

 

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

@EVEAdmin , because that is text column, And that is limitation as of now.

 

Please log an idea or vote https://ideas.powerbi.com/ideas/

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.