Hi Team, I have a requirement to add a filter control on my dashboard that I want it to default to the latest date anytime the dashboard is opened.
Also, the control should appear as a drop down list of dates in descending order instead of a calendar widget. This is because, I want to be able to show only those dates that are present in my dataset, for users to select from.
Any inputs on how this may be implemented?
Hi @MKB
Welcome to the Quicksight community and thank you for posting your question!
I tried the below way but only thing i am missing is sorting the dropdown by Descending order . I will see if i can try anything on this.
Step 1 - Do you have any date field that is of date type? If yes, the create a calculated field as shown below (because we need to make sure it is a string as you said you don’t need a calendar)
Go to your dataset → Edit dataset → in data preparation page please create a calculated field (not in the analysis).
formatDate({YourDateField}, 'yyyy-MM-dd')
Step 2 -
Create a parameter → Type : String → Select Single value (as shown in the below image) → Click create
Step 3 - Link parameter with filter
Add formatDate as filter to your visuals and link it to parameter you have created above → Click Apply
Step 4 - To add dropdown
Go to the parameter you created → Click 3 dots and Add control (as shown below)
Step 5 - To show latest date on visuals
Apply a date filter on your visuals to show always the latest data on the visuals -
Please let me know if this helped
Thank you,
Shravya
Thank you @shravya for the detailed steps and screenshots. Unfortunately, the above solution doesn’t seem to be working. Curious if it worked at your end i.e. when you open the dashboard, it defaults to the latest date?
Also, any idea why the parameter control shows a “select all” even if in the control settings I have checked “Hide Select all option from the control values if the parameter has a default configured”.
Hi @MKB
Yes, if you have followed the Step 5 as is, you can see the latest data on the visuals in dashboard. I am able to see it. My dashboard has march 31st 2025 as the latest data and i see it always whenever i open it.
If you don’t provide any default value it shows “Select All” in the dropdown. I have provided the default value and selected “Hide Select all” option from controls - I don’t see “Select all” now.
Could you please share some screenshots of configuration to understand why its appearing on your visuals.
Thank you,
Shravya