How can I hide multiple columns in PBI Desktop

[Anonymous]

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 ?

[ThomasFuchs]

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]

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]

It works exactly as you've described!  Great Tip

[jdbuchanan71]

@ThomasFuchs

I wish I could give you 100 kudos for this, thank you!

[Anonymous]

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

[v-lili6-msft]

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

[Greg_Deckler]

I don't believe that multi-select is supported.