Forum Discussion

figdor's avatar
figdor
Regular Visitor
9 years ago
Solved

When using forecast feature, why is the line sometimes flat and other times bumpy?

I've just started to use the forecasting feature on some time series data in Power BI desktop and it all seems to work fine except that depending on the data the forecast is sometimes flat, and other...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    figdor

     

    I find the crux of this issue. When we use "Auto" Seasonality, it will detect as yearly. There is not too big difference on yearly changes, when this value change split into daily, it almost "flat" every day.

     

     

    If you want to forcast it more accurate, you can change the Seasonality into a bigger value, like 12 (evaluate on monthly).

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

figdor

 

I find the crux of this issue. When we use "Auto" Seasonality, it will detect as yearly. There is not too big difference on yearly changes, when this value change split into daily, it almost "flat" every day.

 

 

If you want to forcast it more accurate, you can change the Seasonality into a bigger value, like 12 (evaluate on monthly).

 

 

Regards,

figdor's avatar
figdor
Regular Visitor
9 years ago

This is great! Thankyou so much. I should have checked that out, it kind of makes sense now in that the forecasts that were working properly were those that had greater change over the years.

 

Thanks again :)