Forum Discussion
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 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.
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,
Just select "Yes" as shown below.
3 Replies
- v-chuncz-msft
Community Support
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" )
- AnonymousNot applicable
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
Anonymous,
Just select "Yes" as shown below.