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

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.

Rasmusrock's avatar
Rasmusrock
Helper II
10 years ago

Home tab here.

 

 

 

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    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

    • Rasmusrock's avatar
      Rasmusrock
      Helper II
      10 years ago

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

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        10 years ago

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

         

        Regards,

        Bhavesh