Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Can you check if you edit a properly seasonality?
Please refer to thread below:
Regards,
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
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).