March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I've been struggiling with this issue for some time now and not sure what the issue is.
I have got monthly data extracts, which provide submission data. One column provides 'start of the week' and I use this for the timeline and then a Count of submissions to create a basic line chart. My aim was to add the Forecasting feature within Power BI to Forecast 6 months.
My issue is, the Forecast line will only appear if I ignore the last months data. If it is set to 0 (which I want, as I want it to create a forecast taking into account every month) it will error and say there is a date issue. If I ignore the last month, it works..
I have got 5 months worth of data, and everytime I update it, it works, but only if I ignore the latest month. Any ideas?
The forecast line dissapears entirely. I then get a error staying the data is too irregular.
Would it possible to provide a sample of the data with the dates but with any private data removed.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Usually there are staff numbers inbetween this. I also had to strip alot of data out to fit in below. But you should be able to replicate my visual with the data below:
Month | Signed off by employee(Yes/No) |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
14 October 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
27 November 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
09 December 2024 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
06 January 2025 | yes |
Hi @Kai_PBI
Does it still occur if you set the interval to Points instead of Months?
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
126 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
181 | |
121 | |
82 | |
70 | |
54 |