How to format date column header as MMM-Goal?
I have date column which is aggregated as month and filtered for current month. I want the month to show as MMM-Goal. For eg: in June, the column should say ‘Jun-Goal’.
Can anyone please explain how to achieve this?
Hi @krtse,
QuickSight only accepts date and time when dealing with date formatting, it does not allow the addition of other text; you can find the supported formats here:
A couple work arounds you could explore though:
You could build a calc. field with the switch function; though that can be a bit tedious building out depending on the number of value options.
If your filter has a control or is operating off a parameter, you could change the column name to include the parameter value:
Hi @krtse,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Hi @krtse,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you
