Mastering Microsoft Power BI

Forecast line

The Forecast line, exclusive to standard line chart visuals, utilizes predictive forecasting algorithms to generate both specific forecast data points as well as upper and lower boundaries. The report author has control over the number of data points to forecast, the confidence interval of the forecast (for example, 80 percent, 95 percent), and can apply formatting to distinguish the forecast from the actual data points. Additionally, the forecasting feature allows authors to optionally exclude a number from the last data points. This Ignore last property is useful for excluding incomplete periods as well as evaluating the accuracy of the forecast relative to recently completed periods.

In the following example, the clustered ...