Forum Discussion
performance against forecast
Hi wynhodgkiss , hello lbendlin, thank you for your prompt reply!
As lbendlin mentioned, the built-in forecasting tool will not meet your requirements.
As a workaround, you can use the Remaining Forecast method described in the article below:
Showing actuals and forecasts in the same chart with Power BI - SQLBI
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Apologies lbendlin , maybe I wasn't clear enough. The table above is just a representation of the values, the actual visualisation is a line chart with a "Sales" measure. Using the inbuilt forecasting my "Sales" line extends out into the future but each time an actual value is loaded the forecast value for that month dissapears.
I want to keep the forecast line in place so users can see performance against forecast
You cannot modify the built-in forecasting but you can replace it with your own code.
