Dimension area

Dimensions can be row dimensions, column dimensions, or slicer dimensions.

Note: Dimensions for which member selections have been made can be removed from a report by clicking the X button for "Remove dimension and clear selections" in the Dimension list. However, there must always be at least one row and one column dimension in a report. Therefore if only two dimensions remain in a report they will not have X buttons.

Dimensions example

In the following screenshot:

Note: Regular (enlarged) charts do not have a dimension area. To customize the dimensions of an enlarged chart, you can do either of the following:

  • View the chart as a table to arrange the dimensions, and then switch back to a chart view. To view the chart as a table, do one of the following:
    • Click View as: Table on the toolbar.
    • Select View menu> View as table.
  • Use the Rearrange report dialog. To open the Rearrange report dialog, do one of the following:
    • Click Table options / Chart options> Rearrange report.
    • Select View menu> Table options / Chart options> Rearrange report.

In this section:

Slicer dimensions (Tables)

Column dimensions (Tables)

Row dimensions (Tables)

Drag and Drop (Tables)