# Change parameter format from Pivot Table column

**URL:** <https://community.amazonquick.com/t/change-parameter-format-from-pivot-table-column/44694>\
**Category:** Q&A\
**Tags:** qls-community, dashboard-embed, developer, quick-sight\
**Created:** [April 7, 2025, 3:37pm UTC](https://community.amazonquick.com/t/change-parameter-format-from-pivot-table-column/44694 "2025-04-07T15:37:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robson\_Fernandes](https://avatars.discourse-cdn.com/v4/letter/r/2acd7d/32.png) [@Robson\_Fernandes](https://community.amazonquick.com/u/Robson_Fernandes)\
**Post date:** [April 7, 2025, 3:37pm UTC](https://community.amazonquick.com/t/change-parameter-format-from-pivot-table-column/44694/1 "2025-04-07T15:37:11Z")

</div>

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

 ![Captura de Tela 2025-04-07 às 12.32.21](https://d1wl4jav5dp96l.cloudfront.net/original/3X/8/b/8b6d0cb960a2fdb26d567cc6130d5414d04a6905.png)

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

How can I format parameter visualization inside the title?

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [April 7, 2025, 5:55pm UTC](https://community.amazonquick.com/t/change-parameter-format-from-pivot-table-column/44694/2 "2025-04-07T17:55:48Z")

</div>

Hi @Robson_Fernandes and welcome to the Quick Sight 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:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/6/7/67515610ef9416e5012d35502a6f655db02cc596.png)

---

<div class="post-metadata">

**Author:** ![ArunSanthosh](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/arunsanthosh/32/3292_2.png) [@ArunSanthosh](https://community.amazonquick.com/u/ArunSanthosh)\
**Post date:** [April 10, 2025, 7:39pm UTC](https://community.amazonquick.com/t/change-parameter-format-from-pivot-table-column/44694/3 "2025-04-10T19:39:08Z")

</div>

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 Quick Sight SA