Add a moving average to a chart in a paginated report (Report Builder)
Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools
A moving average is an average of the data in your series, calculated over a defined period of time. In paginated reports, the moving average can be shown on the chart to identify significant trends.
The Moving Average formula is the most popular price indicator used in technical analyses. Many other formulas, including mean, median and standard deviation, can also be derived from a series on the chart. When when you specify a moving average, each formula might have one or more parameters that must be specified.
The Tutorial: Add a column chart to your report (Report Builder) walks you through adding a moving average to a chart, if you'd like to try it with sample data.
When a moving average formula is added in Design mode, the line series that is added is only a visual placeholder. The chart calculates the data points of each formula during report processing.
Built-in support for trend lines isn't available in Reporting Services.
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.
Add a calculated moving average to a series on the chart
Right-click on a field in the Values area and select Add Calculated Series. The Calculated Series Properties dialog opens.
Select the Moving average option from the Formula list.
Specify an integer value for the Period that represents the period of the moving average.
Note
The period is the number of days used to calculate a moving average. If date/time values are not specified on the x-axis, the period is represented by the number of data points used to calculate a moving average. If there is only one data point, the moving average formula does not calculate. The moving average is calculated starting at the second point. If you specify the Start from first point option, the chart will start the moving average at the first point. If there is only one data point, the point in the calculated moving average is identical to the first point in your original series.