Column Properties (SSAS Tabular)


Applies To: SQL Server 2016

This topic describes tabular model column properties.

Sections in this topic:


PropertyDefault SettingDescription
Column NameThe name of the column as it is stored in the model and as it is displayed in a reporting client field list.
Data FormatAutomatically determined during import.Specifies the display format to use for the data in this column. This property has the following options:


 Decimal Number

 Whole Number




After you set a data format, you can set properties that are specific to each format. For example, if you choose the Currency format, you can set the number of visible decimal places, choose the thousands separator, and choose the currency symbol.


If the column values contain images, see Representative Image.
Data TypeAutomatically determined during import.Specifies the data type for all values in the column.
DescriptionA text description for the column.

In certain reporting clients, if an end-user places the cursor over this column in the field list, the description appears as a tooltip.
HiddenFalseSpecifies whether the column is hidden from reporting client field lists.

Set this property to True to hide this column in the display. For example, columns that contain identifiers or keys are typically not useful to the end user.

If you hide a column from the reporting client, the field is not suppressed in the model data. The field is still visible if you create a query against the model. A hidden column can still be used for grouping or sorting.

The Hidden property does not provide any form of data security. To secure data, use row filters in Roles. For more information, see Roles (SSAS Tabular).
Sort By ColumnSpecifies another column to sort the values in this column. A relationship must exist between the two columns.

This value must be the name of an existing column. You cannot specify a formula or measure.

Reporting Properties

For detailed information on setting Power View table behavior properties, see Configure Table Behavior Properties for Power View Reports (SSAS Tabular).

PropertyDefault SettingDescription
Default ImageFalseSpecifies which column provides an image that represents the row data (for example, a photo ID in an employee record).
Default LabelFalseSpecifies which column provides a display name to represent row data (for example, employee name in an employee record).
Image URL/Data Category (SP1)FalseSpecifies the value in this column as a hyperlink to an image on a server. For example: http://localhost/images/image1.jpg.
Keep Unique RowsFalseSpecifies which columns provide values that should be treated as unique even if they are duplicates (for example, employee first name and last name, for cases where two or more employees share the same name).
Row IdentifierFalseSpecifies a column that contains only unique values, allowing that column to be used as an internal grouping key.
Summarize ByDefaultSpecifies reporting client tools apply the aggregate function SUM for column calculations when this column is added to a Field list. To change the default calculation, select it from the dropdown list. This property applies only to columns of type that can be aggregated.
Table Detail PositionNo Default Field SetSpecifies this column or measure can be added to a set of fields from a single table to enhance the table visualization experience in a reporting client.
  1. In the model designer, in a table, select a column.

  2. In the Properties window, click on a property, and then type a value or click the down arrow to select a setting option.

Power View Reporting Properties (SSAS Tabular)
Hide or Freeze Columns (SSAS Tabular)
Add Columns to a Table (SSAS Tabular)

Community Additions