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

[Anonymous]

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

[amitchandak]

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

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