Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO: 
Power BI Report Builder 
Power BI Desktop
A moving average is an average of the data in your series, calculated over a defined period of time. In Power BI paginated reports, the moving average can be shown on the chart to identify significant trends.
To add a moving average to a chart:
Right-click on a value in the chart and select Add Calculated Series, as shown in the following image. The Calculated Series Properties dialog opens.
In the Calculated Series Properties dialog, select the Moving average option from the Formula dropdown 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 aren't specified on the x-axis, the period is represented by the number of data points used to calculate a moving average. If there's only one data point, the moving average formula doesn't 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's only one data point, the point in the calculated moving average will be identical to the first point in your original series.
Related content
- Add a moving average to a chart in a Power BI paginated report
- Tutorial: Add a column chart to your report (Report Builder)
- Formatting a chart in paginated report (Report Builder)
- Charts in Power BI paginated reports (Power BI Report Builder)
- Add empty points to a chart in a Power BI paginated report (Power BI Report Builder)