Share axis scales in a scorecard

Contents[Hide]

1. Overview

By default, copies of a chart that are generated in a scorecard/report share the same Numeric and Date/Time axis scales. However, there may be cases where you want to change this behavior. For example, you have a line chart where it is more important to see the shape of the curve than to compare Y-values.

The following walkthrough shows you how to share or un-share the axis scales of chart copies in a report or scorecard. In order to share axis scales between different charts, use the Share the scale with another chart or axis option described in the article on Using chart properties.

The data for the following example comes from a data cube that joins the SalesOrderDetail, SalesOrderHeader, and Person tables from the AdventureWorks sample database. You can build a similar data cube by following the steps from this article.

Create a scorecard

Create a new scorecard and set it up as follows:

  1. Drag the Full Name hierarchy from the data cube to the grouping area (drop a column or hierarchy here to repeat content for each value).
  2. Drag the Full Name hierarchy from the data cube to the body area; it will appear as a data label for showing the full name of a sales person. 
  3. Select the body area and add a background and separator lines from the Look properties.
  4. Drag the Product hierarchy from the data cube to the child grouping area (drop a column or hierarchy here to repeat content for each value within every value above).
  5. Drag the Product hierarchy from the data cube to the child body area; it will appear as a data label for showing product names.
  6. Go to the toolbar, click Data Visualization, and then select Line to add a line chart.
  7. Drag the line chart to the child body area.
  8. Add LineTotal as a measure and OrderDate as a row hierarchy to the line chart.
  9. Add a second line chart to the child body area and configure it the same as the first chart.

Initial scorecard design
Initial scorecard design

2. Only share scales in the same grouping

Select the second line chart and go to its Properties. Check the Only Share Scales In Same Grouping property.

Only Share Scales In Same Grouping property
Only Share Scales In Same Grouping property

Switch to View mode to see the scorecard.

Observe that the line charts in the second column all share axis scales (both on the left and bottom axes). The line charts in the third column share axes only inside the grouping.

View the scorecard when sharing scales only inside the grouping
View the scorecard when sharing scales only inside the grouping

3. Stop sharing scales with copies

Select the second line chart and go to its Properties. Click Left Axis 1 to view and modify the left axis properties.

Uncheck the Share Scale With Copies property.

Share Scale With Copies property
Share Scale With Copies property

Switch to View mode to see the scorecard.

Observe that the line charts in the third column do not share the left axis scale. On the bottom axis, the Only Share Scales In Same Grouping property still applies.

View the scorecard
View the scorecard

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri