How to show default current week in the slicer each time you open the report?

[Anonymous]

How to show default current week in the slicer each time you open the report? And how to make it Dynamic?

TIA
Tanisha

[rajendraongole1 · Accepted solution]

Hi @Anonymous - To implement current week on report multiple approaches are there.

Hope you already added Week Number and Year Columns in your date table.

create a calculated column 

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

apply it on page or visual level filter that current week.

other approaches reference links:

Solved: Selecting default - week value dynamically - Microsoft Fabric Community

Solved: How to set current week as default slicer - Microsoft Fabric Community

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!