Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rasmusrock
Helper II
Helper II

Unhide columns in PowerPivot 2010

Hi,

 

How do i un-hide a column that i have hidden in PowerPivot 2010?

 

I have a PowerBi report based on a datamodel in Excel PowerPivot 2010.

 

To ease the use of the model, i have hidden the columns that have no interest for the client by right-clicking the column, and using the 'hide from client tool' option. Different from PowerPivot for excel 2013 and beyond, it does not grey-out the column, but completely removes it - and i cant seem to find a way to unhide them - which is annoying.

 

Hope someone can help me, since it is probably quite simple! 

 

Best regards,

 

Rasmus

1 ACCEPTED SOLUTION

Press the Show Hidden Button and It will show your hidden column/tables. Go to the column, Right Click and unhide from client tools.

It is not turned on at this moment and that's why you can not see previously hidden items.

 

This is tried and tested and it does work.

 

Thanks

 

Regards,

 

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

9 REPLIES 9
BhaveshPatel
Community Champion
Community Champion

Hi Rasmus

 

There is a Hide/Unhide button in Powerpivot 2010 under the design Tab. 

 

I have atttached a photo for your reference.

 

image_thumb_2AF2AF32.png

 

Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Hi BhaveshPatel,

 

Thanks for the reply.. However, it does not look like that in my screen, instead it shows 'add' where yours show 'Hide and unhide', and then 'delete', 'freeze' and 'width' beside it where yours has 'add' and 'delete'.

 

Any suggestions?

Many thanks,

 

Rasmus

Can you please send me the screenshot of your screen.

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Sure, here it is:

 

Design tab.PNG

 

🙂

Also the screenshot of Home Tab Please.

 

If you have Show Hidden turned on, you’ll be able to see the previously-hidden tables and columns. If you have Show Hidden turned off, you will not be able to see the previously-hidden items.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Home tab.PNG

Home tab here.

 

 

 

Press the Show Hidden Button and It will show your hidden column/tables. Go to the column, Right Click and unhide from client tools.

It is not turned on at this moment and that's why you can not see previously hidden items.

 

This is tried and tested and it does work.

 

Thanks

 

Regards,

 

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

I worked, thank you very much - dont know why i didnt see that 🙂

Yes. We all can miss sometime small details. Thank you for providing the screen shots quickly.

 

Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.