Default Behavior - Date Filter to Most Recent

[irnm8dn]

I am currently using a fiscal calendar for my dashboard.  As pictured below, I have empowered the users to select Year and Week. The ideal scenario would allow me to default the slicers to current year and most recent week.

Is there any ability to do this?  

As an aside, the week number is formatted to text to ensure the chronological layout is correct.

Thanks for the help.

[v-chuncz-msft · Accepted solution]

@irnm8dn,

You may add an additional slicer by creating a calculated column. Also please vote this idea up.

IsCurrentYear =
IF ( Table1[Year] = YEAR ( TODAY () ), "Yes", "No" )

[v-chuncz-msft · Accepted solution]

@irnm8dn,

You may add an additional slicer by creating a calculated column. Also please vote this idea up.

IsCurrentYear =
IF ( Table1[Year] = YEAR ( TODAY () ), "Yes", "No" )

[irnm8dn]

Thanks @v-chuncz-msft

Can you help me understand the dax statement so I can learn how this solves the need?

[v-chuncz-msft · Accepted solution]

@irnm8dn,

Just select "Yes" as shown below.