Paginated Report highlight default Month/YY in the drop down box

[Babette]

Report has a "From Month: " (p_FromMonth) drop down box that contains MM/YY values from Dataset (values range from Jan 2020 to Dec 2027).   

The p_FromMonth parameter is defaulted to current month and it does show "Nov 2024" in the box.

Users ran the report and if they want to change the MM/YY from "Nov 2024" to "Dec 2024" by click on drop down box, it shows values starting from the very first value which is Jan 2020.   

Is it possible to have the drop down box show at the "Nov 2024" value so Users don't have to scroll quite a bit to get to "Dec 2024"?

Thank you.

[FarhanJeelani]

In Power BI Paginated Reports, unfortunately, there isn't a direct way to auto-scroll the drop-down to the default or selected value. However, you can consider these approaches:

1. Sort in Descending Order: Update the dataset to display the dates in descending order. This way, recent dates like "Nov 2024" are closer to the top of the list, reducing scrolling.

2. Filter by Year First: If possible, add a separate year filter parameter, allowing users to quickly narrow down the month selection within the desired year.

These options can make navigation quicker for users without extensive scrolling.

please mark this as solution if you feel this works for you

[Babette]

hi, thank you for your suggestion. Sort descending .. i'll check with the client their preference.

[FreemanZ]

hi @Babette ,

you can sort the visual(slicer?) by mm/yy with descending order.