Forum Discussion
Sum on forecasting data - line chart
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,
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
7 Replies
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-reportsRegards,
Daniel He
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.
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
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