Forum Discussion

PBI_2K26's avatar
PBI_2K26
Icon for Advocate I rankAdvocate I
28 days ago
Solved

Dynamic default Year Value

Hello ! I'm looking for a way to have a Year slicer that displays all available years, while automatically selecting the current year by default (e.g., 2026 today, 2027 next year). The default selec...
General Comment
power bi
Tutorial Requests
  • ShahRukhSameer's avatar
    ShahRukhSameer
    28 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.

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
28 days ago

Hi PBI_2K26​,

Unfortunatly, these is no way that you can select the year dynamically, you can go with the solution provided by other users but if you are fine to use date as your slicer then you can achieve your reuirement, and you can set it to relatively select current year.

As Microsoft introduced an updated native Date Picker experience in June 2026, along with the necessary updates to Power BI. Make sure your Power BI Desktop is updated to the latest version.

Once updated, simply add a Date Slicer, go to Format → Slicer settings, and select “Date picker.” The updated native Date Picker will then be available without requiring any custom or paid visual.

For more details for Date Picker, kindly refer official documentation here.

You can select it manualy:-

Or you can click on relative to select relative dates.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUserand Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
�� Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!