Change parameter format from Pivot Table column

Hello, I’m trying to change the data format visualization inside a Value name from pivot table

I would like to see movement (Mar2025) instead of movement 2025-03-01

How can I format parameter visualization inside the title?

Hi @Robson_Fernandes and welcome to the QuickSight community!
To format the parameter value in a header, you would need to alter the date format in your parameter control when creating a control:

Hi @Robson_Fernandes , @Brett ,

Formats specified for parameter controls are honored only in the control display. Including the parameter in the column title will still default to yyyy-MM-dd HH:mm:ss format (and display based on parameter’s granularity setting). Right now, workaround I can think of is to format the date parameter in desired way in a calculated field and overlay a single cell table, with that calculation, on the first table’s column header. This works only if you are in free-form layout mode.

Regard,
Arun Santhosh
Pr QuickSight SA

1 Like