Preview Content - log in or become a member

PowerPivot hide columns and unhide

In this step by step PowerPivot Tutorial I will show you how to using PowerPivot hide columns and unhide them. For the purpose of this tutorial I will use PowerPivot in Excel 2013.

Other Versions of Excel:

  • PowePivot Excel 2013 (v3)
    • This blog post has been written using PowerPivot in Excel 2013
  • PowerPivot Excel 2010 (v2) - SQL Server 2012
    • The step we will use should be similar in Excel 2010 with PowerPivot SQL Server 2012 (v2)
  • PowerPivot Excel 2010 (v1) - SQL Server 2008 R2
    • The step we will use should be similar in Excel 2010 with PowerPivot SQL Server 2008 R2 (v1)

Who is it for?

  • People who would like to improve user experience with PowerPivot model and hide some columns

See below PivotTable taht uses PowerPivot model and notice that we have quite a few IDs (Primary Keys and Foreign Keys). In our case those IDs are meaningless and users should not use them therefore in we will hide the columns from users.

PowerPivot unwanted fields

 

PowerPivot hide column

Are you a member? Log In

Membership plans from just 6.00 USD*

* Currency: USD (US Dollar )
2500+ accounts so far

Plans:
Bronze
6.00 USD
Silver
9.00 USD
Gold
12.00 USD
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Duration:
Bronze
Silver
Gold
Valid for: 1 month 6.00 USD
sign up
9.00 USD
sign up
12.00 USD
sign up
Valid for: 3 months
10% off
16.00 USD
sign up
24.00 USD
sign up
32.00 USD
sign up
Valid for: 6 months
20% off
28.00 USD
sign up
43.00 USD
sign up
57.00 USD
sign up
Valid for: 1 year
30% off
50.00 USD
sign up
75.00 USD
sign up
100.00 USD
sign up
Valid for: 2 years
40% off
86.00 USD
sign up
129.00 USD
sign up
172.00 USD
sign up
Valid for: lifetime
50% off
108.00 USD
sign up
162.00 USD
sign up
216.00 USD
sign up


Did you find this page useful?
+3  |  -0
(3 Votes)