Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
Sharon's avatar
Sharon
Microsoft Employee
10 years ago

Forecasting

Description Forecasting is used to predict next points in time series data sets. The prediction in this example is based on trend and seasonality.     Prerequisites (The sample .pbix file...
Forecasting Showcase.pbix635 KB
ScriptInstallPackagesWithWorkaroundsForecast.R1 KB
Advanced Analytics Visualizations
ScottFerguson's avatar
ScottFerguson
Helper II
9 years ago

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.

 

 

  • ironryan77's avatar
    ironryan77
    Kudo Commander
    9 years ago

    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.

    • ScottFerguson's avatar
      ScottFerguson
      Helper II
      9 years ago

      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.

      • ironryan77's avatar
        ironryan77
        Kudo Commander
        9 years ago

        No, this is what I'm saying.  For the built-in visual, the forecast option is only present when one series is plotted.

  • boefraty's avatar
    boefraty
    Microsoft Employee
    9 years ago

    See also: 
    https://community.powerbi.com/t5/R-Script-Showcase/Forecasting-in-R-Visual-R-Custom-Visual-Power-Query-Line-Chart/m-p/104473

     

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy