Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How can I hide multiple columns in PBI Desktop

How can I hide multiple columns in PBI Desktop whcih are not required to de displayed in the Report tab.

I see that there is an option to do this one column at a time, Can we do this faster than this ?

Need Help

7 Replies

  • ThomasFuchs's avatar
    ThomasFuchs
    Frequent Visitor
    7 years ago

    Open the relationship view, click on the first column you want to hide and then use ARROW UP/DOWN together with SHIFT for multi select. Once all relevant columns are selected, press the MENU-key (between ALT and CTRL or use SHFIT+F10) and then select "Hide in report view".

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It works exactly as you've described!  Great Tip

    • SusmithaSree's avatar
      SusmithaSree
      Icon for Advocate I rankAdvocate I
      6 years ago

      In addition to this option, the following solution worked for my tables.

      Steps:

      1. Go to Relationship View
      2. Select the table in which the columns needs to be hidden
      3. In "Fields Pane", Select the columns to be hidden while pressing down "CTRL + SHFIT" Keys.
      4. Once all the columns are selected then right click and click on "Hide in Report View"

       

      Hope this helps.

       

      Thank You

      Susmitha

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     ok Thanks .. Hoping this will be part of the tool in the upcoming version .. will make life little easier

    • v-lili6-msft's avatar
      v-lili6-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      hi, Anonymous

      It is not supported for now and for your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.

       

      Best Regards,

      Lin