Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Data is irregular to forecast in Power BI Desktop

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. Forecast line chart.png

 

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

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/

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
Adebimpe
Frequent Visitor

Does anyone has a new solution to this, please. The solution link above is now obsolete

v-frfei-msft
Community Support
Community Support

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/

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.