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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
PowerBI_77
Frequent Visitor

My forecast is constant each year!

Hi all!  I'm using Power BI to produce a forecast for the next 5 years, based on monthly volume data since 2007.  My chart of the forecast looks like this (green line is actual monthly data, dotted black line is trend line and solid black line is forecast):

 

5yr Forecast.JPG

 

As you can see, a trendline on the data shows a gradual upward trend.  However the 5 year forecast shows the exact same values each month for each year - e.g.  Jan-19, 20, 21, 22, 23 all show the same forecast value.  All the Februarys show the same forecast value, etc.  It's just the same pattern repeated 5 times.  Is this what is meant to be shown?  Unless I'm missing something obvious, I would think that Power BI would show the forecast data increasing each year based on the existing trend?  

 

PS I have set seasonality to '12' as my data is monthly.  

 

Regards,

Lee

 

7 REPLIES 7
Mohanad-Mustafa
Advocate III
Advocate III

I am having the same issue even with 4 months of data and only forecasting one month of data. If I use the Anamolies option istead of forecase, it gives a bit more accurate results when it analyses the sales histroical data. The forecase option is far from reailty, I think the problem lies with the type of data we are feeding into Power BI, it might less fluctuations in the data to be able to tell the real forecast. 

v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @PowerBI_77,

 

Please leave the "Seasonality" option empty for a test.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Yuliana.  Thanks for your reply.  If I leave the Seasonality option blank (so it resorts to the 'auto' setting), I get the following chart:

 

Forecast Auto Seasonality.JPG

 

This forecast seems to more closely match the trend of the data, but I now lose any variation in the data and I just get a straight line! 

 

Regards,

Lee

Hi All.  Just a small update on this issue.  I've now tried experimenting with a date slicer on the dataset and I've noticed that if I exclude a portion of the early data, at a certain point Power BI will give me a forecast which looks more sensible.  For example if I only look at monthly volumes from Sep-2011 onwards, I get the following chart:

Data with Slicer.JPG

 

At least now, my forecast is showing variation and is following the trendline (dotted line).  My theory is that Power BI will only apply a similar trend to the forecast data if the R-squared value is above a certain value?  Or if the correlation coefficient is above a certain value?  

 

Just for comparison, here again is what the forecast looks like if I reset the slicer (using the entire dataset):

Data with Slicer Reset.JPG

 

Does this seem consistent with anyone elses experience with forecasting in Power BI please?  

Regards,

Lee

Greg_Deckler
Super User
Super User

Hmm, any chance you could share some data, would be interesting to play around with this.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Hi Greg.  Thanks for your reply.  Unfortunately I'm unable to share that data although it's just based on a simple table of month names, e.g. Jan-07, Feb-07, etc and a figure for each month.  Are you able to replicate something similar to see if you get the same strange forecast, i.e, is the forecast the same pattern for each projected year?  

Regards,

Lee

Seems like a lot of typing...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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