Hi,
Goal: Change visual title based on the default filter of the table visual. Show Month and Year
It’s a rolling date, showing only reports for a month and its defaulted to rolling dates
Can anyone show me step by step how to do it
Then my goal is not really to show it on the control or filters in the upper section of the dashboard. I just want it reading from the backend whats the filter for that table and show the month year
Hi @johnjasonalfonso and welcome to the Quick Community!
So to have a rolling date as a visual title, the value of the rolling dates need to be captured within a parameter for it to be applied to a title.
First you create your parameter. One for the starting Date and one for the ending date based on your rolling date criteria.
After the parameters are created, then you can go to the title or subtitle and input the names of the parameter.
After you do this, then any value the parameter holds will dynamically change your visual title. Now to apply your parameters to the filters so the visuals will be affected.
Let me know if you have any further questions and I hope this helps!
@JacobR Thanks for replying. The rolling dates is there so that it wil remain in that month for a given reporting date. since today is Feb, I want the table to show only Feb.
My goal is to be able to have a visual title of Feb 2026. Month and date only of that filtered visual.
Hi @johnjasonalfonso ,
As that would be a cool feature to have, this is currently not possible in quicksight. You cannot input a calculated field in a title or have parameters built onto other parameters to isolate parts of your rolling date. The way I demonstrated is so far the only way to input your rolling date into the visual title.
I have attached the ‘feature-request’ tag to this post to help increase visibility to the Quick Team.
Discard the rolling rate in this query. I just want to show in the visual title the filtered month in my table. Just month and the year. Is that possible?
Hi @johnjasonalfonso ,
Unfortunately not. You can change the date format to ‘MMM YYYY’ (Feb 2026), but when the parameter takes the value, it takes it in the date’s native format ‘yyyy/mm/dd’. I messed around with creating a calculated field that converts the date to a string and the parameter takes that value but that did not work in my environment. There are many limitations when working with date fields which is why I attached the ‘feature-request’ tag to this post.
Hi @johnjasonalfonso ,
So there was a similar scenario in a recent post here in the community that could be a potential solution for you. Here is the post (Add data from column to title - Q&A - Amazon Quick Community). As it was noted, it is not a perfect solution, but I did want to point this out to you.
