I need to dynamically show in a tile this month’s name but after creating the parameter I managed to show the date in YYYY-MM-DD format but not the name.
How to show the exact name of the month?
Also I need the same for last three months.
So the report would show “January-February-March” in the title
Hi @pantelis ,
I would refer back to a previous community post that is a similar scenario:
How to Display Dynamic Month in Table Title Using Parameters? - Q&A - Amazon Quick Community
Check this out and let me know if you have any questions. I believe this will get you most of the way there. The last three months instance might entail a slightly different solution, but try out the solution outlined in the past community post and we can go from there.
Hi @JacobR . Thanks for the reply.
I have seen this topic and I have done the same but the result is that the title is showing in YYYY-MM-DD format. I want the title to be “Sales in March” and not “Sales in 2026-03-01”.
How can I achieve this?
hi @JacobR . Any news please on this?
Does Quicksight have this ability? To show the month name instead of the number?
Thanks
Hi @pantelis ,
The difficult part with the scenario is to make the title dynamic it will have to be through a parameter. And since parameter’s job is to only raw data, you cannot have it based on a calculated field. You would have to create a control, and in the control, it lists out all of the months. You might be able to do a little more if you used a ‘formatDate()’ based calculated field as a filter for your visual, but it will still require the control to be manually change.
The second approach that I can think of is a bit unconventional, but you can create a single-cell table visual that contains a calculated field using formatDate() to generate your desired month string (including the three-month format). Remove or hide the table’s title, then position this table visual directly on top of your main visual where the title would normally appear. It acts as a dynamic “pseudo-title” that can display any formatted text your calculated field generates. This approach can potentially give you more flexibility but try it out and let me know how it goes!
Hi @pantelis ,
Just following up here as it has been a while since last communication on this thread. Were the resources provided above useful for your case?
Please feel free to reply if you have any outstanding questions or need anything clarified further. If we don’t hear back within the next 3 business days, I’ll go ahead and mark this thread as solved.
Thank you
