Forecasting
I copied the Power BI page, and replaced the R visual with a trend line using the forecasting functionality in the Analytics (second image). After removing the date hierarchy setting from the x-axis - the forecasts look similar.
Filtered for U.S.
is it possible to plot one forecasted series and one actual values series on the same chart? It doesn't seem like Power BI's built-in visual supports this, but maybe an R-visual would.
The built-in forecast feature does include the option to include actual side-by-side with projections.
Does anyone know if the engince that drives analytics is any different from R? The results look the same, so it would appear not.
No, this is what I'm saying. For the built-in visual, the forecast option is only present when one series is plotted.
A work around is to overlap two individual charts - below you will see forecast for Sales and Product Cost from Adventure works. However, the legend is lost as each chart only has one variable.
A trade-off with R charts I have noticed is that slicers do not apply to the chart. Has that changed?