Forum Discussion
Dynamic default Year Value
Hi PBI_2K26,
There isn't really a native way to make a standard Year slicer dynamically change its selected value based on TODAY().
A relative date slicer can be dynamic, but it doesn't give you the exact behaviour you're asking for: showing all years while automatically selecting the current year.
One workaround is to create a measure such as:
Current Year Flag =
IF (
MAX ( 'Date'[Year] ) = YEAR ( TODAY() ),
1,
0
)
You can then use that measure as a filter for the relevant visuals, while keeping the Year slicer available for users to override it. However, the slicer itself won't visually show the current year as selected.
A bookmark can give you a default selection, but you'd have to update the bookmark when the year changes, so it isn't truly dynamic.