Export (0) Print
Expand All

Default Field Set Dialog Box

SQL Server 2012

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

With the Default Field Set dialog box, you can define the selected table’s columns and measures, as fields, in order, that are automatically added to a Power View report when the table is selected in the field list. For detailed descriptions and configuration information, see Configure Default Field Set for Power View Reports.

Fields in the Table

Lists the table’s columns and measures, as fields, that can be added to the default field set (in order). Hold down the Shift key to select a range, or the Ctrl key to select multiple individual fields.

Default fields, in order

Lists, in order, the default fields (columns and measures) that will be displayed in a Power View report when the table is selected in the field list.

Add

Select a field in Fields in the table, and then click Add to add the field to the default field set.

Remove

Select a field in Default fields, in order, and then click Remove to remove the field from the default field set.

Up

Select a field in Default fields, in order, and then click Up to move the field to a higher order in the default field set.

Down

Select a field in Default fields, in order, and then click Down to move the field to a lower order in the default field set.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft