Edit

Chart legend - hide items in a paginated report (Report Builder)

  • Article

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

By default, any series added to a non-Shape chart in a paginated report will be added as an item in the legend. For pie, doughnut, funnel, and pyramid charts, any series added to the chart will add individual data points in the legend.

You can hide any item on the legend. When you hide a legend item, it will still appear in the chart. This is useful in situations where you do not want to show more information for a series that is added to the chart. For example, if you have added a calculated series like a moving average to the chart, you may want to hide this entry in the legend so that more information is only shown for the original series.

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 hide an item from display in the legend

  1. Right-click on the series you want to hide and select Series Properties.

  2. Click Legend. Select the Do not show this series in a legend option.

    Note

    You cannot hide a series for one group and not for the others. If you have added a field to the Series Groups area, all series belonging to this group will be hidden.

See Also

Formatting the Legend on a Chart (Report Builder and SSRS)
Formatting Data Points on a Chart (Report Builder and SSRS)
Change the Text of a Legend Item (Report Builder and SSRS)
Add a Moving Average to a Chart (Report Builder and SSRS)
Legend Properties Dialog Box, General (Report Builder and SSRS)