Dynamically showing or hiding columns

Q&A
,
1

Does QuickSight support dynamically showing or hiding columns in a table or pivot table based on:

a filter,
a parameter,
or a user selection?

The goal would be to control column visibility depending on context (e.g., selected year, scenario, or a toggle), without having to duplicate visuals.

2

Hi @01267ts

If I understand correctly, you want the pivot table to show the columns based on user selection. For instance, if the user selects “selected year”, then the visual has to display selected year and likewise.

If that is the requirement, then you may have to create parameter, add control and write a calculated field like below one and use it in the visual. So that, the visual will dynamically change based on user selection.

Example: ifelse(${Parameter}=‘Selected Year’,{Selected Year},${Parameter}=‘Scenario’,{Scenario},NULL)

Here is the reference Using calculated fields with parameters in Amazon Quick - Amazon Quick

Let me know if you need anything else

Thanks,

Kripa

3

Hi @01267ts

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @01267ts

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!

5

Hi @Xclipse ,

Sorry for the delay. I was not able to follow the reference, I will definitely try and get back.

However, the new update (Reader Customization) supports my requirement.

Thanks,

Kripa