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, 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.
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 |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |