We have an analysis where we need to give control and filter capabilities per month. Having a date picker makes no sense because the data are by month. We have a “yyyy MM” string calculated field that is applied as a filter to which is attached a dropdown multiselect control. What we need is that when loading the dashboard only the last N items in the list are selected in the control.
See example of what we need as a default when the dashboard is loaded (example with the last 6 months).
One problem in our case is that QuickSight date format only seems to work at a highest “day” granularity. So using the date filter/control does not work.
Isn’t there a filter within a control to just select the top or last N values in the control?
While I agree that having the ability to filter controls or more dynamic default options would be extremely useful, this is a current limitation with QuickSight. Dynamically setting which values are selected by default is not possible but I’ll mark this as a feature request to promote visibility to the AWS support team.
Hi @Matthieu,
I have not tested myself to see if this is possible but was able to find some documentation that may relate a bit to your case. Let me know if this could help with your scenario or if you have any additional questions:
The date picker with a month format is not a working solution. Because it is still a - date - picker which will be highly confusing and potentially leading to wrong analysis. Because if a user selects 20205-09-01 to 2025-09-15, the full month of data are displayed. We would need a - month - picker. So for this Quicksight date picker needs to for allow lower granularity than days, which I don’t think is a feature either.
