Sum on forecasting data - line chart

[Anonymous]

Hello folks,

I have a question about the forecasting feature under the analysis panel of the line chart. I successfully run the forecast but is there an easier way that I can get the "sum" of the forecast value rather than exporting to excel? I can do show data but it won't give me the sum. I am just trying to answer questions such as "how much sales will we get next year/Quarter in total?"

Thanks in advance,

[Anonymous]

Does anyone have an idea on this?

Thank you so much.

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous,

From your description, I suggest you to use the Q&A function in Power BI Desktop.
Reference:https://docs.microsoft.com/en-us/power-bi/desktop-qna-in-reports

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft

I just tried Q&A but it does not seem working to me. From the picture below, you will see I already have the forecast value in 2019. However, if I ask Q&A. It is Blank.

[v-danhe-msft]

Hi @Anonymous,

Based on my test, it could work on my side:

If the Q&A could not identify what you have entered, you could use the Add synonyms to tables and columns function:

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-qna-in-reports#add-synonyms-to-tables-and-columns

Regards,

Daniel He

 

[Anonymous]

can you share how you get this calculation in this card. 

I have a similar issue. I want to display the lower forecast value on card.

can anyone help?

[Anonymous]

Hello @v-danhe-msft

The problem is the forecasting value will not be shown in the table so the Q&A cannot reach the data. If you look at the picture below, green line is the actual data and the most recent data is in October, which is shown on the table down below. However, forecasting value of year 2019 is now shown in the table.