Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Kai_PBI
New Member

Forecasting tool - issue using 'ignore the last'

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?

Kai_PBI_0-1736407522018.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Kai_PBI ,
I agree with SamWiseOwl , and here's what I'd like to add.

The first thing that needs to be applied to the x-axis is the date hierarchy

vheqmsft_0-1736488307285.png

Then on top of that you need to drill down to the month level

vheqmsft_1-1736488354363.png

Then turn on the predict button to make it happen

vheqmsft_2-1736488393093.png

As you reported, it is not possible to make predictions without regular intervals, just as if you drill down to the day level again, it will suggest that it is not possible to make predictions because the date of the previous data point, is not the same as the date interval of the next date point. The only way to do normal separation is by month, year or quarter.

Best regards,
Albert He


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @Kai_PBI ,
I agree with SamWiseOwl , and here's what I'd like to add.

The first thing that needs to be applied to the x-axis is the date hierarchy

vheqmsft_0-1736488307285.png

Then on top of that you need to drill down to the month level

vheqmsft_1-1736488354363.png

Then turn on the predict button to make it happen

vheqmsft_2-1736488393093.png

As you reported, it is not possible to make predictions without regular intervals, just as if you drill down to the day level again, it will suggest that it is not possible to make predictions because the date of the previous data point, is not the same as the date interval of the next date point. The only way to do normal separation is by month, year or quarter.

Best regards,
Albert He


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

Kai_PBI
New Member

The forecast line dissapears entirely. I then get a error staying the data is too irregular. 

Kai_PBI_0-1736419901443.png

 

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:

MonthSigned off by employee(Yes/No)
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
14 October 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
27 November 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
09 December 2024yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
06 January 2025yes
SamWiseOwl
Super User
Super User

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors