Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
datanau001
Helper III
Helper III

Forecast Seasonality

‎03-09-2020 04:37 AM

Dear experts,
I have used the Forecast analytics in one of my reports however I need some help to understand how to better choose the option "Seasonality". You'll see attached a print screen where I have data from Mar 2019 to Feb 2020 and I want to forecast the coming 4 months.
In this case I would set set as seasonality 12 points, because it is the sample I have (12 Months). But for 12 it does not show the values fom upper and lower bounds. If I change it to 11 then upper and lower bound will show up and as I keep changing seasonality the forecast values will keep changing too.

 

Seasonality.jpg
So, in my case, with this 12 months sample, what is the correct value I have to put as seasonality?

 

Thank you 

Marcelo

 

Labels:
Message 1 of 6
18,434 Views
2 ACCEPTED SOLUTIONS
v-yingjl
Community Support
Community Support

‎03-10-2020 01:29 AM

Hi @datanau001 ,

 

The Seasonality in forecast means the number of points in a recurring seasonal pattern.

So in my opinion, since your sample data has 12 months, when you set seasonality as 12 points, it will show the forecast results depending on this. When you set seasonality as other points below 12, it will show a range result.

 

For further information about forecast, you can refer the following Microsoft blogs and cases that could help you:

  1. https://community.powerbi.com/t5/Desktop/Forecasting-12-month-rolling-totals/td-p/605110
  2. https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/td-p/124766
  3. https://community.powerbi.com/t5/Desktop/Forecasting-in-Power-BI-The-Theory/td-p/365736
  4. https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-...

 

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Message 4 of 6
18,398 Views
0
5 REPLIES 5
Anonymous
Not applicable

‎11-05-2020 06:31 AM

My seasonality icon in my forecast pane is set to auto and I cannot change it.  any ideas?  

Message 6 of 6
17,552 Views
0
v-yingjl
Community Support
Community Support

‎03-10-2020 01:29 AM

Hi @datanau001 ,

 

The Seasonality in forecast means the number of points in a recurring seasonal pattern.

So in my opinion, since your sample data has 12 months, when you set seasonality as 12 points, it will show the forecast results depending on this. When you set seasonality as other points below 12, it will show a range result.

 

For further information about forecast, you can refer the following Microsoft blogs and cases that could help you:

  1. https://community.powerbi.com/t5/Desktop/Forecasting-12-month-rolling-totals/td-p/605110
  2. https://community.powerbi.com/t5/Desktop/Forecast-Functionality-in-PowerBI/td-p/124766
  3. https://community.powerbi.com/t5/Desktop/Forecasting-in-Power-BI-The-Theory/td-p/365736
  4. https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-...

 

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Message 4 of 6
18,399 Views
0
datanau001
Helper III
Helper III
In response to v-yingjl

‎03-10-2020 04:45 AM

Thank you Yingjie Li!

 

It is exactly what I've been looking for.

 

Regards

Marcelo

 

Message 5 of 6
18,392 Views
0
amitchandak
Super User
Super User

‎03-09-2020 05:10 AM

Refer, if this can help

https://powerbi.microsoft.com/pt-br/blog/introducing-new-forecasting-capabilities-in-power-view-for-...

 



Message 2 of 6
18,413 Views
0
datanau001
Helper III
Helper III
In response to amitchandak

‎03-10-2020 04:44 AM

Thank you Amit!

 

Exactly what I've been looking for.

 

Regards

Marcelo

 

 

 

Message 3 of 6
18,393 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All