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
TravisKale's avatar
TravisKale
Helper I
9 years ago

Thanks for the great visual. 

 

I am getting weird x Axis (date) labels.   2016.2, 2016.4 and they don't seem to line up with February 2016 and April 2016.  Attached is a png image of what i am seeing.  I also included a standard pbi visual to show the correct dates.

 

Am I missing a formatting option?

 

 

 

  • mjc's avatar
    mjc
    Frequent Visitor
    9 years ago

    Attached is a copy of the actual data used in the original births.csv file which I obtained from the pbix.

    I got this by simply creating a new table on the report page, added all columns with no summarisation then used the export data option from that table.
    As dates are exported from Power BI using a date-time format I used excel to reformat the Calendar Month column as just a date.  I deliberately used a US format (mm//dd/yyyy) which might be more widely usable though this should automatically be recognised by Power BI anyway.  If it is not and you use something different then just format in excel to suit your needs.


    Obvioulsy this doesn't really gain you anything since the information was all already embedded in the pbix but it does allow you to fix the errors seen when looking at queries.

    Of course, the technique is something that might be useful in other situations where you are missing a source file and want to recreate it so hopefully this helps someone.

    (attached as a zip file since csv attachments are not supported on the forum)

    births.from.pbix.csv.zip39 KB
  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy