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:
