Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Getting Automatic Forecast Data Into a Matrix

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?

 

 

 

Need Help

2 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.