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.
Hi, I am using Line Chart together with its Forecasting function to monitor monthly sales. The previous month data (which is Feb) is uploaded in the PowerBI.
However, after a data refresh, I am not seeing the actual Feb Sales reflecting in the line chart, as well as there is no automatic forward month forecasting. It just stopped at actual Jan Sales.
Could someone help to advise if PowerBI is able to do automatic forward month forecasting? And also, how to make the actual Feb Sales appear on the line chart?
My current resolution is to recreate the page every month with the same visuals, in order for actual last month Sales and automatic forward month forecasting to be reflected in the visual. Thanks.
Solved! Go to Solution.
Hi @Anonymous ,
As far as I know, Power BI will only display the data in data model. So please make sure you have refreshed your report and the data in Feb 2023 has been loaded into data model.
Then you may refer to this offical blog to learn more details about forecast line.
For reference: Apply forecasting
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-rzhou-msft ,
Thanks for the info. Yes, it's resolved after I refresh my report. Thanks!
Best regards,
Sarah
Hi @Anonymous ,
As far as I know, Power BI will only display the data in data model. So please make sure you have refreshed your report and the data in Feb 2023 has been loaded into data model.
Then you may refer to this offical blog to learn more details about forecast line.
For reference: Apply forecasting
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.