Choosing the Measure Order in a Chart

You can reorder how measures are displayed in a chart, including displaying them as overlapping bars.

Prerequisites

You have a bar chart that has at least two measures.

Context

Use the chart builder to reorder the measures in the chart. You can drag the measures to change their order. In the Color section you can change which measure is at the front and how the measure is displayed, whether as a bar or as a triangle. (When you change all the measures to triangles, at least one of the measures stays as a bar.)

Note
If you add a dimension to the Color section, the chart changes to show the measures as separate bars. When you remove the dimension from Color the measures are again displayed as overlapping bars.

Procedure

  1. Select your chart and open the Builder.
  2. To change the order, select one of the measures and drag it up or down.

    The bars in the chart change order and the legend values are also rearranged to reflect the new order.

  3. In Color, set the pattern and color for each of your measures.
  4. To move a bar to the front, select Start of the navigation pathShow As Next navigation step Layered Bars Next navigation step FrontEnd of the navigation path.
  5. To change the bar to a triangle, select Start of the navigation pathShow As Next navigation step TriangleEnd of the navigation path.

Results

Your chart is updated to reflect the new order and display of the measures.