Forecasting
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?
I did try this approach of using overlapping charts, but that doesn't work either. What I want to do is to plot one forecast series and one actual series on the same (or overlapping) chart. But the problem is that after I add a second series to the same line chart, the forecasting disappears. In my chart, I'm trying to plot the actuals from January 2016 to December 2016; the other series from January 2017 to December 2017. So the x-axis should be the same for both series, and this is why I need one actual and one forecast series. Make sense?
Another problem with overlapping is that tooltips will not work on the chart in back.
Yes, slicers do definitely apply to R visuals if that is what you're asking. Not sure though if it's possible to plot one actual and one forecast series on the same chart.