Forum Discussion
Between date slicer - calender selection
Hi Ritaf1983 danextian Zanqueta Thank you all for your suggestions.
So it means currently in Power BI calender data picker it is not possible to select the year picker, as you can see in the image below when the calender is selected first it shows month picker option, when I select the month picker it opens a month picker. After that when I select the year at top it only shows date picker not the year.
And selecting the arrows are the only options to select the year.
Hi Sandy_22
My suggestion is to use a Year (Dropdown) slicer together with a Date (Between) slicer as the standard user experience when working with more than ten years of data. This approach is simple and efficient for users, as it allows them to quickly jump to a specific year without repeatedly navigating through the calendar using arrows. It also avoids relying on the calendar control for large date ranges, which can be slow and inconvenient in the Power BI Service.
In summary, combining a Year dropdown with a Between date slicer provides a clearer, faster, and more user-friendly solution for reports with long historical periods.
Please check this solved topic: Solved: Year slicer not filtering the date range slicer - Microsoft Fabric Community