Hide or Freeze Columns (SSAS Tabular)
Applies To: SQL Server 2016
In the model designer, if there are columns that you don't want to display in a table, you can temporarily hide them. Hiding a column gives you more room on the screen to add new columns or to work with only relevant columns of data. You can hide and unhide columns from the Column menu in the model designer, and from the right-click menu available from each column header. To keep an area of a model visible while you scroll to another area of the model, you can lock specific columns in one area by freezing them.
When you hide a column, you have the option to hide the column while you are working in the model designer or in reports. If you hide all columns, the entire table appears blank in the model designer.
In the model designer, select the table that contains the column that you want to hide.
Right-click the column, then click Hide Columns, and then click From Designer and Reports, From Reports, or From Designer.
In the model designer, select the table that contains the columns that you want to hide.
Click on the Columns menu, and then click Hide and Unhide.
In the Hide and Unhide Columns dialog box, locate each column that you want to hide, and then deselect one or both of In Designer and In Reports.
In the model designer, select the table that contains the columns that you want to freeze.
Select one or more columns to freeze.
Click on the Columns menu, and then click Freeze..
When a column(s) is frozen, it is moved to left (or front) of the table in the designer. Unfreezing the column does not move it back to its original location.