Skip to content

Latest commit

 

History

History
52 lines (34 loc) · 3.01 KB

add-scale-breaks-to-a-chart-report-builder-and-ssrs.md

File metadata and controls

52 lines (34 loc) · 3.01 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Add scale breaks to a paginated report chart
Find out about using a scale break to display two distinct ranges in the same paginated report chart area in Report Builder.
kfollis
kfollis
09/25/2024
reporting-services
report-design
how-to
updatefrequency5

Add scale breaks to a paginated report chart (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

A scale break is a stripe drawn across the plotting area of a chart to denote a pause continuity between the high and low values on a value axis. This axis is usually the vertical, or y-axis. Use a scale break to display two distinct ranges in the same chart area in a paginated report.

:::image type="content" source="../../reporting-services/report-design/media/rs-multipledatarangeschart-scalebreak.gif" alt-text="Screenshot of a chart with a scale break.":::

Note

You can't specify where to place a scale break on your chart. The chart uses its own calculations based on the values in your dataset to determine whether there is sufficient separation between data ranges to draw a scale break on the value axis, or y-axis, at run time.

An example of a chart with scale breaks is available as a sample report. For more information about downloading this sample report and others, see Report Builder and Report Designer sample reports.

Note

[!INCLUDEssRBRDDup]

Enable scale breaks on the chart

  1. Right-click the vertical axis, and then select Axis Properties. The VerticalAxis Properties dialog opens.

  2. Select the Enable scale breaks box.

Change the style of the scale break

  1. Open the Properties pane.

  2. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object, named Chart Axis by default, are displayed in the Properties pane.

  3. In the Scale section, expand the ScaleBreakStyle property.

  4. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing. For more information about scale break properties, see Display a series with multiple data ranges on a chart (Report Builder).

Related content