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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi there!

First of all, awesome visual! It took me a week to script the ets forecasting in R on my data, and I've been able to get what I want, but then the problem is that it generates a completely new set of data, unrealted to the existing model in Power BI. Your visual solves this problem by integrating the R script (very similar to what I have) into Power BI, so now I can use measures. Great work.

 

Afew things missing here: the Y-axis is poorly marked, if we're talking about millions of dollars on the Y axis. Also, no labels. So, I decided to clone this visual and create my small variation. Standing on the shoulders of giants, as they say

 

All I've done so far is adjusted the R script to also populate a table of values along with the graph. I left the rest untouched.

I got to the point that suits me for now (I hope to keep improving) and I can see needed results on the web when I run pbiviz start command.

But when I try to package the visual, the packaged custom visual for PBI Desktop doesn't have any of those changes... What am I doing wrong?

boefraty's avatar
boefraty
Microsoft Employee
9 years ago

You didn't call "pbiviz new" command, instead you are updating the existing one. So you'll need to do two things:

1) change "guid" field inside "pbiviz.json" to be different string

2) call "pbiviz package" command from command line ( inside the folder of visual)

 

See more here

https://github.com/Microsoft/PowerBI-visuals/tree/master/RVisualTutorial

 

 

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