Forum Discussion

Krizz83's avatar
Krizz83
Regular Visitor
9 years ago
Solved

Forecasting feature

Hi, I am trying to do a forecast as it is described in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-analytics-pane/ But i cannot see the Forecast group. I see al...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Do you have more than 6 data points?

  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Can you post a screen shot of your visualization that includes the fields being used? When I have gotten this to work, I have had a Date Hierarchy in my Axis. This is a field with a Data Type of "Date". Then I had a Decimal Number field in my Values. Visualization is a Line chart. 

     

    Forecasting does not work in the Service yet. Version is 2.39.4526.362 64-bit (September 2016). English language. I have all of the Preview features enabled, File | Options and settings | Options | Preview Features. You need to restart Power BI Desktop after enabling Preview Features.

Krizz83's avatar
Krizz83
Regular Visitor
9 years ago

Thanks for replying.

 

I have now tried with 3, 12 and 30 datapoints. Always same result, no Forecast group.

Also, I doublechecked the version of PowerBI Desktop it is updated to the latest version.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Can you post a screen shot of your visualization that includes the fields being used? When I have gotten this to work, I have had a Date Hierarchy in my Axis. This is a field with a Data Type of "Date". Then I had a Decimal Number field in my Values. Visualization is a Line chart. 

 

Forecasting does not work in the Service yet. Version is 2.39.4526.362 64-bit (September 2016). English language. I have all of the Preview features enabled, File | Options and settings | Options | Preview Features. You need to restart Power BI Desktop after enabling Preview Features.

  • Krizz83's avatar
    Krizz83
    Regular Visitor
    9 years ago

    Thansk smoupre.

    Converting the columns to date types did the trick. I can now see the Forecast group.

     

    :-)

     

     

    • m1032499's avatar
      m1032499
      Frequent Visitor
      9 years ago

      Hi,

      I tried to apply forcasting on my sample data, but I could not see any forcast option in the analytics pane.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        m1032499 impossible to diagnose if you don't tell us anything about the chart and what's on it. What type of column are you using for the axis?