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
Anonymous
Not applicable

Date range max date should be defaulted to today's date.

roopesh_1-1599844880156.png

Every time I open the report I need the max range to default to today's date.

Can you please let me know how I can achieve this?

 

Thank you

Roopesh

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , I doubt you can do much on range.

 

Option 1

use a relative date filter on page <=today (page level filter) -- last 5 or 10 years including today

 

Option 2

Say we create a measure like this and use that visual filter to slicer then slicer will show fewer dates but the filter will not apply

Before Today = if('Date'[Date]<date(2019,12,31),"Yes","No")

 

So what need do is, you need have this as Slicer on-page  and visual level filter too for Date slicer

 

Option 3

Other slicer options are

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]&"")

 

 

Month Type = Switch( True(),
eomonth(Date[Date],0) = eomonth(Today(),0) ,"Current Month" , //This Month
eomonth(Date[Date],0) < eomonth(Today(),0) && ,"Previous Month" , //last Month
eomonth(Date[Date],0) > eomonth(Today(),0) && ,"Next Month" , //last Month
[Month Year]
)

 

Month Type = Switch( True(),
year([Date]) = year(Today())-1,"Last Year" ,
year([Date])= year(Today()),"This Year" ,
Format([Date],"YYYY")
)

Greg_Deckler
Super User
Super User

@Anonymous Use a relative date filter or you will need to create a column like:

Column = IF([Date]=TODAY(),"Today","Rest")

 

Then you would need a slicer for that. But that will create havod for a range slicer unless you are tricky about it and have it calculate out the default range that you want when assigning "Today". There's really no good, clean way.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

Top Solution Authors