Using 'Forecasting' analytics in Desktop, how can I get the forecasted data in tabular form?

[jboyd170]

The forecasting function in 'analytics' creates a good graphic as shown below where I can hover over to see 'forecasted' value, upper bound amount and lower bound amounts.   I'd like to be able to access this 'forecasted' data in tabular form so that I can use the forecast data in other parts of my report or dashboard.  When I select back to a tabular visualization from line graphic, the forecasted data does not appear.   

For example, I'd like to complement the graphic below with a card that has the 'forecasted' sales for 3 months out, or a slider that lets me select a future date and see the forecasted sales for that date.   

Thanks for the help. 

[ahines · Accepted solution]

Have you tried exporting the data from the graph with the forecasts? That is what I have done before to access the forecasted data and brought it back into my Power BI file. 

Did I understand what you are trying to do correctly?

[jboyd170]

The solution works.  I was able to export the data to a CSV and load it back into PowerBI.  However, I was hoping there was an automated way to access the forecasted data to avoid export and re-loading.  

It would be preferable that the forecast data become part of the data model that I could access.  For example, I'd like to create a dashboard that shows the forecast sales line graph the rest of the year and also access key forecasted data for specific calendar dates like year-end and show in a 'card' on the same report.  That way, I can see the key forecasted data without hovering over the graphic.  

[ahines]

I agree. It would be nice if we were able to automatically access the forecasted data.