Forum Discussion
Dynamic default Year Value
- 10 days ago
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.
Hi PBI_2K26 ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
Regards,
Chaithanya