Default current week filter selection when opening report

[khoirockfeather]

I have a multiple selection filter on week. Do you know if there is a way I can set the default selection as the current week when open the report?

[Gabry · Accepted solution]

Hello @khoirockfeather ,

sure. You can achive this by modifing your calendar table.

You need to add a calculated column on your calendar table that looks like this:

Current Week =
IF(
'Calendar'[Week Number] = WEEKNUM(TODAY()) &&
'Calendar'[Year] = YEAR(TODAY()),
"Current Week",
Calendar'[Week Number]
)

Then you publish your report with the filter set on "Current week", every time the data gets updated also the filter will