Forum Discussion

khoirockfeather's avatar
khoirockfeather
Frequent Visitor
2 years ago
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?

 

 

Need Help
Show and Tell
  • Gabry's avatar
    Gabry
    2 years ago

    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

1 Reply

  • Gabry's avatar
    Gabry
    Super User
    2 years ago

    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