Forecasting Issues

[kymiller17]

With the forecasting function in powerbi I have occasionally encountered an issue with a certain data set where the forecast did not produce a confidence interval for the first year.  It happens at a seemingly random rate throughout that data set I havent noticed any trends and its not just data sets out of a certain subsection, but more often that not it does succesfully produce it.  

Here are some examples

The First picture is an example of when it didnt succesfully forecast, the second one is an example of when it did.  I've attached the excel forecasting info as well.  The third and fourth are both examples of when it didnt but with just the data provided by excel vs powerbi.

If anyone knows anything as to why this may be happening, and how to fix it it would be greatly appreciated.

Thanks so much,

Kyle Miller

[kymiller17]

https://drive.google.com/drive/folders/1JX-e6WgNoWhCsugvIHpoxj7Eeqa4ML0p?usp=sharing

I'm attaching a google drive folder above with some of the data from the excel file, if anyone could take a look.

I'm also attaching a link back to the previous thread I had on this issue for reference.

https://community.powerbi.com/t5/Desktop/Issues-with-forecasting/m-p/306974#M135821

Thanks again,

Kyle Miller

[v-sihou-msft]

@kymiller17

Can you check if you edit a properly seasonality? 

Please refer to thread below: 

https://community.powerbi.com/t5/Desktop/When-using-forecast-feature-why-is-the-line-sometimes-flat-...

Regards,

[Anonymous]

P.S. Thanks for the link, but we are not having a flat forecast problem. Rather, our problem is that the first point in the forecast (incorrectly) has a confidence interval of 0

Here is a screen shot

https://drive.google.com/open?id=1ds31DXa3pAlU7ACW2XpOXtKYuy8mDOUz

[Anonymous]

I'm replying for my colleague who posted this for me: yes, we have tried different seasonality settings and it did not change anything (seasonality for these graphs is one data point).