Data is irregular to forecast in Power BI Desktop

[Anonymous]

Hi,

I created a forcast trendline and added 180 forecast points. I found the forecast line is missing since I updated the data source yesterday,  the error is : a forecast can't be created because the timeline isn't evenly spaced. the dates or numbers in a valid timeline must have a consistent gap between consecutive points.

I think the forecasting line chart can automatically fill in some missing values to provide a forecast. Do you know the maximum number of missing data points that the forecast line chart to generate a forecast graph? E.g. if the total number of missing values is less than 50%(maybe 40% ) of the total number of data points, the algorithm will insert some points to performing the forecast, but if more than 50%(maybe 40%) , the forecast will fail.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Continuous dates is the key for the function Forecast. For more details, please check the third - party blog.

http://www.erikhudzik.com/2017/01/16/power-bi-forecasting-feature-and-when-your-data-is-too-irregular-to-forecast/