Forum Discussion
Forecast Seasonality
Dear experts,
I have used the Forecast analytics in one of my reports however I need some help to understand how to better choose the option "Seasonality". You'll see attached a print screen where I have data from Mar 2019 to Feb 2020 and I want to forecast the coming 4 months.
In this case I would set set as seasonality 12 points, because it is the sample I have (12 Months). But for 12 it does not show the values fom upper and lower bounds. If I change it to 11 then upper and lower bound will show up and as I keep changing seasonality the forecast values will keep changing too.
So, in my case, with this 12 months sample, what is the correct value I have to put as seasonality?
Thank you
Marcelo
Hi datanau001 ,
The Seasonality in forecast means the number of points in a recurring seasonal pattern.
So in my opinion, since your sample data has 12 months, when you set seasonality as 12 points, it will show the forecast results depending on this. When you set seasonality as other points below 12, it will show a range result.
For further information about forecast, you can refer the following Microsoft blogs and cases that could help you:
- https://community.powerbi.com/t5/Desktop/Forecasting-12-month-rolling-totals/td-p/605110
- https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/td-p/124766
- https://community.powerbi.com/t5/Desktop/Forecasting-in-Power-BI-The-Theory/td-p/365736
- https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Thank you Amit!
Exactly what I've been looking for.
Regards
Marcelo
Hi datanau001 ,
The Seasonality in forecast means the number of points in a recurring seasonal pattern.
So in my opinion, since your sample data has 12 months, when you set seasonality as 12 points, it will show the forecast results depending on this. When you set seasonality as other points below 12, it will show a range result.
For further information about forecast, you can refer the following Microsoft blogs and cases that could help you:
- https://community.powerbi.com/t5/Desktop/Forecasting-12-month-rolling-totals/td-p/605110
- https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/td-p/124766
- https://community.powerbi.com/t5/Desktop/Forecasting-in-Power-BI-The-Theory/td-p/365736
- https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Yingjie Li!
It is exactly what I've been looking for.
Regards
Marcelo
