Forum Discussion

Rasmusrock's avatar
Rasmusrock
Helper II
10 years ago
Solved

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...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    10 years ago

    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

BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

Hi Rasmus

 

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

 

I have atttached a photo for your reference.

 

 

Regards,

Bhavesh

  • Rasmusrock's avatar
    Rasmusrock
    Helper II
    10 years ago

    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

    • BhaveshPatel's avatar
      BhaveshPatel
      Super User
      10 years ago

      Can you please send me the screenshot of your screen.

       

      • Rasmusrock's avatar
        Rasmusrock
        Helper II
        10 years ago

        Sure, here it is:

         

         

        :)