Forecadtin

[NeilRoss]

Is there any way to create a table or matrix from a forecast line chart which shows historical data, forecast values, upper and lower values? I know you can "show as a table" but looking to create a separate table?

[v-yueyunzh-msft]

Hi , @NeilRoss 

Based on your description, you want to create a separate table in Power BI Desktop based on the raw data. Right?

We can create tables in the following ways:
(1) Click "New Table" and enter the DAX logical statement that you want to create the table.
(2) Copy the table in Power Query Editor and then process the table to generate a new table.

Best Regards,

Aniya Zhang

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

[NeilRoss]

Hi not sure I understand. How do I extract the forecast values from the forecast chart

[v-yueyunzh-msft · Accepted solution]

Hi , @NeilRoss 

The forecasting feature is only available for line chart visuals. 

For this feature is an expected data generated by the algorithm in the background.There is currently no way to turn this table directly into other visuals.

We can click "Export data" to get the data which generated by Power BI:

Then we can get the generate data , we can connect the excel in Power BI Desktop. After if we can create visual through the data.

Best Regards,

Aniya Zhang

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