Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |