Time Series Forecasting chart

Question

Hello,&nbsp;It is the first time, I am using the time series forecasting chart from the market place.&nbsp; I have a maximum which appears at december 08, 2017 in the line chart.&nbsp; However, this maximum appears at Feb 11, 2018.&nbsp;Should I use a particular date format with this time series forecasting chart or is it an adjusment, I should do into the parameters.&nbsp;Thanks in advance for your assistance.&nbsp;

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
You could get it by custom it in Formatting pane as below:

&nbsp;
and you could also download this sample pbix file and try it.
&nbsp;
Best Regards,
Lin

anonymous · Answer

Hello,&nbsp;I have made some tests with you time series forecasting chart.&nbsp; Here's what I have done.&nbsp;I have use an Excel speadsheet as belowColumn A&nbsp; &nbsp; &nbsp;Column B&nbsp; &nbsp;Column C&nbsp; &nbsp; &nbsp; Column D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column E2016-01-01&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;97&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;482016-01-02&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;932016-01-03&nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;622016-01-08&nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...2018-12-20&nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-12-31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;52&nbsp;Column D contains a date which start from 2016-01-01 to 2016-12-31 (Equal Date Spacing)Column E contains a random value between 25 and 100, using the randombetween function in Excel&nbsp;Column B contains a radom number between 1 and 5Column A start at 2016-01-01 but the next date equal the previous date plus the random value of Column B.&nbsp; That allow us to obtain Unequal date Spacing.&nbsp;Column C is also a random value between 25 and 100.&nbsp;Two graphs were elaborated using your Time Series Forecasting Chart.The first one use Column A and Column CThe Second on use Column D and Column E.&nbsp;The second graph is using an Equal Date Spacing.&nbsp; When we look for a maximum value into the table (max in Column E) the corresponding date in the table is the same as on graph 2.&nbsp;However in graph 1, due to the use of Unequal Date Spacing, when we look at a maximum value (Column C)&nbsp; the corresponding date in Column A is not the one showed on Graph 1.&nbsp;Is there a way to correct that situation?Thanks in advance for your assistance.&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Time Series Forecasting chart

2 Replies

Related content

Forecast in Line Chart

Can't change series color in ribbon chart

Forecasting in a line chart

Forecasting with DAX

Forecasting - Line chart