Default Slicer on Opening Report

[GarethParry]

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

[amitchandak · Accepted solution]

@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