Forum Discussion

sshore's avatar
sshore
Helper I
9 years ago

enabling forecasting

Hello,   I have enabled the Forecasting Function and have restarted Power BI. I even re-installed Power BI.    I look at the options and Forecasting is enable but when I go to my line chart and g...
BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

You can also use R for forecasting. Check out this BLOG

sshore's avatar
sshore
Helper I
9 years ago

BhaveshPatel I have changed the Date to a Date/Time Type and the Value to the Whole Number Type. I am still not able to see the forecasting function. My query has more than 1000 rows. Do you think that this has to many values to use the forecasting option?

  • sshore's avatar
    sshore
    Helper I
    9 years ago

    @BhaveshPatel I found out what the problem was. 

     

    I had our Order date in Months. When you have Months it does not allow for the forecasting option. When I choose year it does pop up. Unfortunetly I work for a Consumer Electronics Start Up so we do not have mass historical data. Do you know if the forecasting function will be enabled for Data grouped in Months?

     

    Thank you for your help!

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi sshore,

     

    Based on my test, we can add a forecast line when the X-axis displays Month values. You can place MonthNo which is number type in X-Axis instead of month names. See:

     

     

    Best Regards,
    Qiuyun Yu