Amazon QuickSight adds hide collapsed columns control for Pivot table

Amazon QuickSight now offers the hide collapsed column control to help users better manage collapsed columns in their pivot tables. Authors can use this control to automatically hide collapsed row header fields, eliminating the need for unnecessary scrolling and making pivot tables look more compact and organized. To learn more, click here.


This is a companion discussion topic for the original entry at https://aws.amazon.com/about-aws/whats-new/2023/03/amazon-quicksight-hide-collapsed-columns-control-pivot-table/
1 Like

This is great!
If we could automatically hide metric columns that only have null values, then we can create a pivot table, where the reader can customize the columns himself, without layering multiple tables over each other.

2 Likes

@thomask This is great! How would you hide the column that contain null though? I only see Pivot options to hide +/- buttons, hide single metric, and hide collapsed columns.

could you show an picture screen for this feature?

Hi @Amanda Is this helpful?

thank you~
Hope there is a screenshot for this feature effect, the doc do not show how the table would be like if you enable the feature.

1 Like

Hi @Amanda,
To hide a field on a table visual, you can select the 3 dots next to the field and select ‘Hide’:

In regards to how it will look on the visual, the field will still be taken in to account when it comes to filtering the table, but the column that you’ve hidden, will no longer show on the visual. If you’d like to export your table, you can choose to export including/excluding your hidden field(s).