Forum Discussion
Dynamic default Year Value
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!