MrExcel.com - Your One Stop for Excel Tips & Solutions

Hide Columns So They Can't Be Chosen

May 03, 2023 - by

Hide Columns So They Can't Be Chosen

Problem: There are some fields in my table that I never want to appear in the report.

Strategy: Use Hide from Report View. There are two ways to find this command.

Click the Data icon along the left edge of Power BI Desktop.

There are three icons to the left of the canvas in Power BI Desktop: The first icon is Reports, then Data, then Relationships. Choose the Data Icon.
Figure 1105. See your tables using this icon.

When you can see the table, right-click any column and choose Hide from Report View.

If you hover over a field in the Fields list, an elipsis will appear. Click the … to access a menu where you can hide the column. This same menu offers the ability to unhide columns that have previously been hidden.

Or, right-click the field in the Fields pane and choose Hide in Report View.
Figure 1106. Hover over a field to reveal the elipsis icon that leads to these choices.

This article is an excerpt from Power Excel With MrExcel

Title photo by Sneha Cecil on Unsplash