Time Scale Projection - Predictive Trendline

[TylerVono]

Hello,

Looking for help with time scales. Trying to find an equation for a projection into 'Day-Of' or through this graph. The dates are basically creation date of job orders, as you can see below from NOV 2022 there has not been a job made since, how do I make a trendline to current day of report.

Moreover, how do I show the future trajectory of this line? Any suggestions?

[Anonymous]

Hi @TylerVono ,

If you have time data in your data source, you can use the forecasting feature. Select a visual, then expand the Forecast section of the Analytics pane. You might specify many inputs to modify the forecast, such as the Forecast length or the Confidence interval. The following image shows a basic line visual with forecasting applied. 

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn

Best regards.
Community Support Team_ Caitlyn

[TylerVono]

Hello v-xiaoyan-msft,

I have a new error now, Data isnt evenly spaced. I am seeing some forums saying that using and merging this new equation: DateTable = CALENDARAUTO() with my x axis data is a way to solve this new problem. Can you tell me if that is what I should do?