Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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")
)
@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.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |