Forum Discussion
Solved
Default current week filter selection when opening report
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?
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
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]
)
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