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
Microsoft EmployeeHi 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.