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 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.
@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.
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).