Your minimum goal should be possible. There is probably a default selection that you can enter that would work here. As mentioned in the Drop-down list and Fixed-size list control article, the default selection has to match your data exactly. So maybe instead of “2024-03-01”, it needs to be “2024-03”, or even "“2024 03”?
Your ideal goal may be possible by switching to a date range control! There is an option there for “last month”.
It does seem that using the date range control could enable us to display data from one month ago by default. However, I am wondering if there is a way to achieve this using a Drop-down list instead.
To provide some context, our current data source is structured on a monthly basis. Because of this, we would prefer to select filters at the month level rather than by specific days.
With the date range control, filtering works from a specific date to another specific date. Given that our data source is organized by month, ideally, we would like to be able to select in the “YYYY-MM” format.
Thank you again for your support and any further guidance you can offer.
