Add or delete a group in a paginated report chart (Report Builder)

Applies to: ✅ Microsoft Report Builder (SSRS) ✅ Power BI Report Builder ✅ Report Designer in SQL Server Data Tools

In paginated reports, click in the chart data region to display the Chart Data pane. Create groups by dragging dataset fields to the Category Groups and Series Groups areas. To add nested groups, add multiple fields to the area.

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

To add a parent or child group to a chart

  1. On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.

  2. Drag a field from the Report Data window to the Category Groups or Series Groups area. To add a parent group, position the cursor in front of an existing group. To add a child group, position the cursor after an existing group.

To edit a category group on a chart

  1. On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.

  2. Right-click the group in the Category Groups area, and then click Category Group Properties.

  3. Add or remove group expressions, filters, sort expressions, and group variables.

  4. Select OK.

To edit a series group on a chart

  1. On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.

  2. Right-click the group in the Series Groups area, and then click Series Group Properties.

  3. Add or remove group expressions, filters, sort expressions, and group variables.

  4. Select OK.

To delete a group from a chart

  1. On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.

  2. Right-click the group in the Category Groups or Series Groups area, and then click Delete.

See Also

Charts (Report Builder and SSRS)