How to: Collect Small Slices on a Pie Chart (Report Builder 3.0 and SSRS)
When pie charts display too many points of data, they begin to look cluttered. To resolve this issue, you can show all data that falls beneath a certain value as one slice on the pie chart.
To collect small slices into one slice, first decide whether your threshold for collecting small slices is measured as a percentage of the pie chart or as a fixed value. Then set the CollectedThreshold and CollectedThresholdUsePercent properties.Set the CollectedThreshold property to either the percentage of the chart that a value must fall below to be collected, or the actual threshold data value for collection. Set the CollectedThresholdUsePercent property to True to use a percentage or False to use an actual value.
You can also collect small slices into a second pie chart that is called out from a collected slice of the first pie chart. The second pie chart is drawn to the right of the original pie chart.
You cannot combine slices of funnel or pyramid charts into one slice.
An example of this chart is available as a sample report. For more information about downloading this sample report and others, see SQL Server 2008 R2 Report Builder 3.0 and Report Designer sample reports.
You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.
To collect small slices into a single slice on a pie chart
Open the Properties pane.
On the design surface, click on any slice of the pie chart. The properties for the series are displayed in the Properties pane.
In the General section, expand the CustomAttributes node.
Set the CollectedStyle property to SingleSlice.
Set the collected threshold value and type of threshold. The following examples are common ways of setting collected thresholds.
By percentage. For example, to collect any slice on your pie chart that is less than 10% into a single slice:
Set the CollectedThresholdUsePercent property to True.
Set the CollectedThreshold property to 10.
If you set CollectedStyle to SingleSlice, CollectedThreshold to a value greater than 100, and CollectedThresholdUsePercent is True, the chart will throw an exception because it cannot calculate a percentage. To resolve this issue, set the CollectedThreshold to a value less than 100.
By data value. For example, to collect any slice on your pie chart that is less than 5000 into a single slice:
Set the CollectedThresholdUsePercent property to False.
Set the CollectedThreshold property to 5000.
Set the CollectedLabel property to a string that represents the text label that will be shown on the collected slice.
(Optional) Set the CollectedSliceExploded, CollectedColor, CollectedLegendText and CollectedToolTip properties. These properties change the appearance, color, label text, legend text and tooltip aspects of the single slice.
To collect small slices into a secondary, callout pie chart
Follow Steps 1-3 from above.
Set the CollectedStyle property to CollectedPie.
Set the CollectedThresholdproperty to a value that represents the threshold at which small slices will be collected into one slice. When the CollectedStyle property is set to CollectedPie, the CollectedThresholdUsePercentproperty is always set to True, and the collected threshold is always measured in percent.
(Optional) Set the CollectedColor, CollectedLabel, CollectedLegendText and CollectedToolTip properties. All other properties named "Collected" do not apply to the collected pie.
The secondary pie chart is calculated based on the small slices in your data so it will only appear in Preview. It does not appear on the design surface.
You cannot format the secondary pie chart. For this reason, it is strongly recommended to use the first approach when collecting pie slices.