Line Chart - Forecast Value

[farriyajawed]

I am using the line graph to show forecast value. I can see the grey are on the graph but when I clink on "Show as table" the values do not reflect on the table. When I download the results in excel, it shows me the columns forecastValue, confidenceHighBound and confidenceLowBound with their corresponding values in the forecast period. I am wondering why I can't see the same table from the graph. 

[edwardcharles]

Been awhile since this was posted -- if you don't want to use Power BI's built in forecasting capabilities I made a video on a work around to visualize this using native visuals: https://youtu.be/_x2VSJaTWYo 

[Anonymous]

Hi @farriyajawed ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

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

[Anonymous · Accepted solution]

Hi @farriyajawed ,

Due to the design of power bi, the forecasting function is only available for line chart visual objects. Therefore, only existing data will be shown in the table.

In addition, we are introducing new forecasting features in Power View in Office 365. In Power View, you can now apply forecasting and postcasting when visualising and browsing data.Forecasting in Power View utilises the built-in forecasting predictive model, which uses exponential smoothing to automatically detect seasonality in the data to provide predictive results for a range of data. Explore the predicted results by adjusting the desired confidence intervals or adjusting outlier data to see how they affect the results.

More detailed information can be found at the link: Introducing new forecasting capabilities in Power View for Office 365 | Microsoft Power BI Blog | Mi....

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[elitesmitpatel]

Hey @farriyajawed 
You need to understand the issue 

• Visual Forecasting: When you apply forecasting to a line graph, Power BI visually represents the forecast and its confidence intervals, but these values are calculated on-the-fly and may not be directly exposed in the "Show as table" feature.
• Table View: The "Show as table" feature typically shows the underlying data used to create the visual but not necessarily the forecast values generated by the visual.
  
  Thank you