Forum Discussion
Is there a way to auto-hide empty columns in a Pivot Table?
I have a massive database and I'm producing a Pivot Table that has over 90 columns, of which many times, less than 20 of them have data, and all other columns are empty. Is there a way to auto-hide the empty columns, other than manually Hiding them?
Ted
2 Replies
In general PivotTable based on data model shall not show fields with no data, however cashed PivotTable shows.
For such sample
let remove data in column B against X and refresh
assuming these PivotTable options are not set
When using a data model for a Power View or PivotTable report, you can hide entire tables or individual columns so that only relevant items appear in the field list.
Hide columns and tables in Power Pivot
add info:
Quick Trick: Resizing column widths in pivot tables
