Forecasting Help

[Anonymous]

Hi All, 

I was hoping someone could give me some insight into forecasting in Power Bi. 

Currently I graph with daily data on it. However when I use the forcasting tool, the line does not seem very accurate. 

It seems to be only looking at the last point, and not taking into account all of the other days data. I assume if it was using the others days data the forcast line would be much steeper. 

I woould like to make the forcast to show for the next 3 months. 

Thanks

[v-yingjl · Accepted solution]

Hi @Anonymous ,

In Analysis pane, when you want to show the next 3 months for forecast, you can set the Forecast Length as 3 months, the Seasonality points is depended on your sample data. For example, if your data has 12 months, you can set the Seasonality points as 12, when it is above or below 12, it will show a range result like the picture you posted previously. 

You can refer the following Microsoft document, cases and blog that could also help you:

1. https://community.powerbi.com/t5/Desktop/Forecast-Seasonality/td-p/964493
2. https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/td-p/124766
3. https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane#apply-forecasting
4. https://powerbi.microsoft.com/fr-fr/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.

[amitchandak]

@Anonymous 

Refer :https://databear.com/forecasting-in-power-bi/

https://www.youtube.com/watch?v=XIlPkyyztho

https://community.powerbi.com/t5/Desktop/How-to-forecast-sales-with-Power-BI/td-p/347779

https://powerbi.microsoft.com/pt-br/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/