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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors