Default Field Set Dialog Box

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.

See Also

Reference

Table Behavior Dialog Box

Concepts

Configure Default Field Set for Power View Reports