Forum Discussion
Sum on forecasting data - line chart
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
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
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
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.
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?