How to change Column header dynamically based on the parameter control

Hi All,
I need to show column header dynamically based on the parameter.
I am having a parameter control with company names A & B like below
image

if I select ‘A’ in the control then we have to show the column header as “Entity” like below
image
if I select ‘B’ in the control then we have to show the column header as “UPN” like below
image

anyone please help me on how to achieve this.

Hello @Rajeshkommi !

You can apply your parameter to the column names in the visual properties menu using the format below:

(1)

(2)
image

(3)
image

One thing to note, this will not change the vales of the column, only the name of the column.

1 Like

Hi @duncan Thanks for your response.

I have created two parameter one for company and other for dynamic column header
1). created calculated field based on the company parameter.

2).and for dynamic column header parameter I added condition as relevant values of company parameter only like below

3). Added the parameter to the column header in the properties

4).If I select “A” in the company control then in the dynamic column header parameter it will showing default value only, here after selecting the value manually in the Dynamic Column Header control then only show the required value in the column header.

image

image

Here my task is if I select the value in the Company control, then automatically populate the value in the “Dynamic Column Header” without manual selection. Please help on this

1 Like

Hello @Rajeshkommi !

That is not currently available in QuickSight. I can mark this as a feature request for the QS team!