Add or remove margins from a paginated report chart (Report Builder)
Applies to: ✅ Microsoft Report Builder (SSRS) ✅ Power BI Report Builder ✅ Report Designer in SQL Server Data Tools
For Column and Scatter chart types in paginated reports, the chart automatically adds side margins on the ends of the x-axis. In Bar chart types, the chart automatically adds side margins on the ends of the y-axis. In all other chart types, the chart does not add side margins. You cannot change the size of the margin.
This topic does not apply to pie, doughnut, funnel, or pyramid chart types.
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 enable or disable side margins
Right-click the axis and select Axis Properties. The Vertical or HorizontalAxis Properties dialog box appears.
On the Axis Options page, set the Side margins property:
Auto The chart will determine whether to add a side margin based on the chart type.
Disabled Bar, column, and scatter charts will have no side margins.
Select OK.
See Also
Formatting Axis Labels on a Chart (Report Builder and SSRS)
Axis Properties Dialog Box, Axis Options (Report Builder and SSRS)
Specify an Axis Interval (Report Builder and SSRS)
Format Axis Labels as Dates or Currencies (Report Builder and SSRS)
Charts (Report Builder and SSRS)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for