Forum Discussion

PBI_2K26's avatar
PBI_2K26
Icon for Advocate I rankAdvocate I
4 days ago

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 selection should be dynamic, so that when users open the report or use "Reset to default," the slicer automatically points to the current year. Is there a native Power BI solution to achieve this behavior?

Thank you !

5 Replies

  • v-kathullac's avatar
    v-kathullac
    Icon for Community Support rankCommunity Support

    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

  • Hi PBI_2K26​, building on Nasif_Azam​  suggestion, you can use "Button Slicer" visual, which has a label section

    Your value is still the "Year Slicer" and then you add a label to "Year". What you can do next is to turn off "Value" and keep only "Label".

    So in backend you're still filtering "Year Slicer" where you have a static value "Currecn Year", which you need. But visually you only show label, which can be dynamic ;)

    Good luck with your work! :)

  • 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!

  • Hi PBI_2K26​,

    Power BI has no native setting that makes a slicer default to "the current year". A slicer always saves the exact value you selected when you published, such as 2026. That fixed value is also what Reset to default goes back to, so next year it would still select 2026.

    The usual workaround is to select a label that moves, instead of a fixed year.

    Option-1: a "Current Year" label in your Date table

    1. Add a calculated column to your Date table:

    Year Slicer = VAR _Year = YEAR ( 'Date'[Date] ) RETURN IF ( _Year = YEAR ( TODAY () ), "Current Year", FORMAT ( _Year, "0" ) )

    1. Sort it in year order. Select the Year Slicer column, choose Sort by column, and pick your numeric Year column. Otherwise "Current Year" would sort alphabetically after all the numbers.
    2. Use Year Slicer in the slicer. Select Current Year, then save and publish.

     

    Option-2: relative date slicer

    If users only ever need the current year and don't need to pick other years, use your Date column in a slicer set to Relative date → This 1 calendar year. It moves forward automatically. However, it doesn't show a list of all years, so it doesn't fully meet your requirement.

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