Forum Discussion
Default Slicer on Opening Report
Hi,
I have a report where the data is split into weeks of the year. I have a slicer which has all the weeks that are contained in the data.
Can i set the slicer to default to the current week -1.
thanks
Gareth
GarethParry , You have to create a new column like this in date table
Week Type =
var _st = today() +-1*WEEKDAY(today() ,2)+1
var _end = today() + 7-1*WEEKDAY(today(),2)
Switch( True(),
[Date] >= _st && [Date] <= _end ,"This Week" ,
[Date] >= _st-7 && [Date] <= _end -7,"Last Week" ,
[Week Name]
)and save that on last week
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
1 Reply
GarethParry , You have to create a new column like this in date table
Week Type =
var _st = today() +-1*WEEKDAY(today() ,2)+1
var _end = today() + 7-1*WEEKDAY(today(),2)
Switch( True(),
[Date] >= _st && [Date] <= _end ,"This Week" ,
[Date] >= _st-7 && [Date] <= _end -7,"Last Week" ,
[Week Name]
)and save that on last week
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA