Table Behavior Dialog Box

SQL Server 2012

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on

With the Table Behavior dialog box, you can configure properties which define the selected table’s default behavior for visualization types and default grouping. A reporting client application such as Power View or PowerPivot, use these properties to enhance the interactivity and presentation experience for end-users. These properties, for example, can be used to control the display list of fields for a table; the display formats of numerical, date, and currency values; and how data is sorted, grouped, and calculated. For detailed descriptions and configuration information, see Configure Table Behavior Properties for Power View Reports.

Row Identifier

Set this property to the one column that contains the key value that is unique and not null for each row. Not every table has a table identifier.

Keep Unique Rows

If the Row Identifier property has been set on a column, set this property to group by the values in Row Identifier instead of the values in this column. For example, if this column has customer names, there can be multiple rows with the same name, such as “John Smith.” If you do not set this property, the reporting client might aggregate all values for all customers named “John Smith” into a single row, if all other selected columns also contain duplicate values. By setting this property, you ensure that each “John Smith” displays on a separate row.

Note Note

Because the columns that the end user selects can affect the grouping, which changes the filter context for expression calculations, model authors must take care to create measures that return the correct results.

Default Label

Set this property to the column that contains a display name or label for each row of data. For example, for a customer table, you might choose a calculated column that concatenates the first name and last name of the customer.

In Power View, this property is used to indicate the primary label field for a card or chart.

Default Image

Set this property to the column that contains the primary image for each row of data. Only one image in a model can be the representative image. For example, in a customer table, this column might contain a URL to a picture of the customer.

The column content type can contain binary or text values.