Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
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.
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:
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |