Forecasting budgets vs actuals

Question

Hi all,&nbsp;I have created a line chart showing the year's budgets vs the actual transactions that have happened.&nbsp;I wanted to use the forecasting ability on the actuals, rather than the trend lines, however this doesn't work out of the box as the forecasting is only possible when a single line is used. Is there a way around this?&nbsp;I did try having 2 charts, laid on top of each other but this has a lot of limitations.&nbsp;Thanks,Sam&nbsp;

amitchandak · Answer

Referhttps://community.powerbi.com/t5/Desktop/Forecasting-Line-chart/td-p/509624

samgibbs1 · Answer

Hi amitchandak&nbsp;&nbsp;Thanks for responding. Apologies if I am missing something, but this link just seems to show how to add forecasting to a line chart. However this only appears to work when you only want to forecast on a chart with one line. I was hoping to be able to have 2 lines showing, but only forecast from one of them.&nbsp;Thanks,Sam

v-frfei-msft · Answer

Hi&nbsp;SamGibbs1&nbsp;,
&nbsp;
Based on my research, it is not supported yet currently. There is an idea and about that you can vote it up and add your comments there to make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20305600-being-able-to-pick-which-line-to-forecast-or-forec
&nbsp;
&nbsp;

Forum Discussion

Forecasting budgets vs actuals

3 Replies

Related content

Budget, actual and variance matrix

Actual vs Forecast vs Budget Variance

Budget vs Actual

Budget vs Actuals Dashboard Best Practices

Budget vs Actual Help