Dynamic header in a table based on the parameter selected

Question & Answer
, , ,
1

Dear QuickSight Expert,

I have set up a table where calculation will change based on the parameter I choose (previous discussion: How to make dynamic calculation in a table based on drop down selection).

Now a follow-up question: Can I set the header in the table to change based on the selected parameter? Following the same example above:

if I choose A, then the header shows “B vs A”;
if I choose B, then the header shows “A vs B”;
if I choose C, then the header shows “A vs C”;
if I choose D, then the header shows “A vs D”.

Can please someone helps me? Thanks!

2

Hello @HHXIAO

Thank you for posting your question.

Could you please give this a try -

Overlaying Text Visuals as Headers:

Create a Text Box Visual: Insert a text box visual above your table to act as a header.
Configure the text to display dynamic content based on the parameter. For instance:

ifelse(
    ${Parameter} = 'A', 'B vs A',
    ${Parameter} = 'B', 'A vs B',
    ${Parameter} = 'C', 'A vs C',
    ${Parameter} = 'D', 'A vs D',
    'Default Header'
)

Ensure the text box updates in real-time with parameter changes.

Place the text box directly above the relevant table column to simulate a dynamic header.
Use the free-form layout to align the text box precisely.

Also try this as suggested in this post → Dynamic Column Names based on calculations - #2 by Wakana

Thank you,
Shravya

2 Likes
3

Hi @HHXIAO , @shravya ,

Calculations can’t be directly used in text boxes. So, right now, you can use a table visual to bring in the above calculation, format the table to turn off visual title, sub title, table header etc, format the cell value to look like header and overlay this single cell table over your actual table header.

Parameters can be used in table headers. Calculations aren’t supported there and calculations can’t currently feed other parameters. However, if you are using your dashboard in embedded context, you can listen to changes in the parameter value from your parent app, derive the table header therein and set the derived value into another parameter that is linked in your original table header. (The overlay approach will work.Just calling out a potential alternate mechanism. )

Regards,
Arun Santhosh
Pr QuickSight SA

3 Likes
4

Hi @ArunSanthosh ,

Thanks for answering my question. I am sorry I didn’t raise the question clear enough.

I want the header text to change based on the selected parameter. If I select A, then the header text will show “B vs A”, if I select B, then the header text will show “C vs A”, if I select C, then the header text will show “D vs A”.

I find the solution suggested by @shravya is helpful, thanks a lot! But it requires a lot of manual work around and might not look perfect optically. In an excel I can easily build a formula and change the text based on my selection, I think there should be a way to do it in QuickSight too. But I am pretty new to QuickSight and is not sure how to do it. Maybe you are able to help here?

1 Like
6

Thank you @ArunSanthosh and @shravya for your reply. It helped me to understand how it works and what is possible / impossible. It seems that this feature is not yet available in QuickSight. Hope there will be future feasure for this.

Here a related discussion for reference. Dynamic Parameter value based based on value of another parameter

2 Likes
7

Hi @HHXIAO,
I’ll go ahead and mark this as a feature request. Did you have any additional questions related to this topic? If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

8

Hi @HHXIAO,
Since we haven’t heard back and I’ve already marked as a feature request, 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 and link this discussion for relevant information if needed.

Thank you!