Line chart - forecasting function

[Anonymous]

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.

 

Forecasting setting in Line Chart  

[Anonymous]

Hi @Anonymous ,

Thanks for the info. Yes, it's resolved after I refresh my report. Thanks!

Best regards,

Sarah

[Anonymous · Accepted 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.