Getting Automatic Forecast Data Into a Matrix

[Anonymous]

So I've got a line chart that utilizes the automatic forecasting. The data is recorded by each individual day (see below)

The only thing is I'd like to display the data by month and then include the forcasted data in a separate column of future months. (like the below but with an additional column with the forecast data). 

Outside of having to write my own DAX calculation or showing as table > exporting > and importing the exported data.... is there a way I can put the forecasted data from line chart one into matrix 2?

[Anonymous]

Hi @Anonymous ,

In fact, I also thought of exporting the data of the visual and then importing it. At present, there is no better way than this.

Best Regards,

Stephen Tao

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

[Pragati11]

Hi @Anonymous ,

No you can't get the automated forecasting in a table or matrix visual.

It is currently only supported for the charts showing trends like Line chart.

Thanks,

Pragati