How to set default on data slicer when open Power BI

[Sunshine123]

Hi, 

I want to create a default on a slicer to the current week, when open Power BI. So it must be dynamic. 

Any suggestions?

Many Thanks!

[v-jayw-msft · Accepted solution]

Hi @Sunshine123 ,

I'd like to suggest you to create a slicer table like below.

slicer = 
var _table = SELECTCOLUMNS(CALENDAR(DATE(2020,1,1),DATE(2022,12,31)),"week",YEAR([Date])&"_"&WEEKNUM([Date]))
var _thisweek = SELECTCOLUMNS(_table,"week","this_week")
return
distinct(UNION(_table,_thisweek))

Then create a measure like below:

measure =
VAR _weeknum =
SELECTEDVALUE ( 'table'[week] )
RETURN
IF (
SELECTEDVALUE ( 'slicer'[week] ) = "this_week",
IF ( _weeknum = WEEKNUM ( TODAY () ), 1, 0 ),
IF ( _weeknum = SELECTEDVALUE ( 'slicer'[week] ), 1, 0 )
)

Add this measure to visual filter set value = 1.

The visual will display value of the latest week when "this week" is selected.

Best Regards,

Jay

[amitchandak]

@Sunshine123 , You have to use workaround. We do not have function support yet

have a column like this in table

Week Type =
var _st = today() +-1*WEEKDAY(today() ,2)+1
var _end = today() + 7-1*WEEKDAY(today(),2)
return
Switch( True(),
[Date] >= _st && [Date] <= _end ,"This Week" ,
[Date] >= _st-7 && [Date] <= _end -7,"Last Week" ,
[Week Name]
)

then save on this week

[Sunshine123]

Thanks @amitchandak! It worked very well. 

How can set a default on "This Week" on the slicer now? Each time when a user will open the file I want "This Week"preselected. 

Many thanks in advance!