Edit

Share via


Adding a moving average to a chart in Power BI paginated report (Power BI Report Builder)

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.

Screenshot of a sales chart.

This article, Add a calculated moving average to a series on a chart in Power BI paginated report shows you how to add it.

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 you specify a moving average, each formula may have one or more parameters that must be specified.

The Tutorial: Add a Column Chart to Your Report (Power BI 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 will calculate the data points of each formula during report processing.

Built-in support for trend lines isn't available in Power BI services.