Dynamic visual title based on month

Q&A
,
1

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

image
image255×162 4.55 KB

2

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.

3

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?

image
image225×536 14.9 KB

4

hi @JacobR . Any news please on this?
Does Quicksight have this ability? To show the month name instead of the number?

Thanks

5

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!