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 thi...
Need Help
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".

SusmithaSree's avatar
SusmithaSree
Advocate 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