Default Behavior - Date Filter to Most Recent

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 ye...

Need Help

Show and Tell

Tips and Tricks

v-chuncz-msft
9 years ago
Anonymous,

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
9 years ago
Anonymous,

Just select "Yes" as shown below.

v-chuncz-msft

Community Support

9 years ago

Anonymous,

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" )

Anonymous

Not applicable

9 years ago

Thanks v-chuncz-msft

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

v-chuncz-msft
Community Support
9 years ago
Anonymous,

Just select "Yes" as shown below.

Forum Discussion

Default Behavior - Date Filter to Most Recent