cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Forecasting tab not available

Hi,

 

Even after updating september version and restarting both the application and desktop, i'm not getting the forecasting tab in the analytics pane. Kindly help.

 

Thanks in advance

1 ACCEPTED SOLUTION
Solution Specialist
Solution Specialist

I figured it out, it was because of the fact, that I had mlutiple lines in visual. When I took away the Legend, Forecast option has shown in Analytics pane.

 

Thanks.

Pavel

View solution in original post

16 REPLIES 16
Regular Visitor

I am having an issue with the forecasting tab not being available.

 

I have tried changing the x axis type from "categorical" to "continuous" but it automatically switches back to "categorical" anyone know what I need to do to change this?

 

Thanks. 

Community Champion
Community Champion

@Vaishnavi_M Forecasting is only availabe with Line chart so if you're using Column chart you won't see the option.

Solution Specialist
Solution Specialist

Hi @ankitpatira. I know that, even though I have no Forecasting in Analytics pane.... as below

 

Výstřižek.PNG

 

Regards

Pavel

@PavelR @Vaishnavi_M You will only get forecasting option when on x-axis you've used column that is of type datetime / number, it won't work with other data type columns. Also it requires more than six data points on x-axis to forecast.

Community Champion
Community Champion

@PavelR I see a space between the first two digits in that x-axis series, which tells me that you're using a text column. The data type must be numeric.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Solution Specialist
Solution Specialist

@KHorseman it is date data type, I have chcecked this.

 

Pavel

Community Champion
Community Champion

@PavelR you must be using some sort of hierarchy then because that's not what dates look like. The automatic date hierarchy treats all the drill levels as text. You will need to create a hierarchy where all the drill levels are numeric, using your own custom columns.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Solution Specialist
Solution Specialist

I figured it out, it was because of the fact, that I had mlutiple lines in visual. When I took away the Legend, Forecast option has shown in Analytics pane.

 

Thanks.

Pavel

View solution in original post

Also done this but the forecasting tab is still missing (PBI april 17' 32 bit version) 

@Einariadone which "this"? There are multiple requirements to get the forecasting option.

 

  1. Must be a Line chart
  2. with no Legend, only a single line
  3. with a numeric or date x-axis
  4. and the x-axis Type must be set to "Continuous" not "Categorical"

If you have done all of those things and it still does not work, please show us a screenshot of the problem visual along with all of its relevant settings.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi,

 

My Forecast tab also not available.

For my x-axis type the default value is "Categorical", I try to change the x-axis type to "Continous" but failed. It automatically change back to "Categorical".  

Hi,

 

My Forecast tab also not available.

I have a problem change my x-axis type to "continuos". Every time I tried to change from "Categorical" to "Continuos", it automatically change back to "Categorical".

 

was missing the "no legend" part works, thanks! 

Your line chart also must have a numeric or date value as the x-axis, not text. Month, for instance, won't work, but month number would.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Solution Specialist
Solution Specialist

Hi @Vaishnavi_M. I have the same issue. I have controled version of PBI, Preview list and all the stuff needed by documentation and I still do not see the Forecasting in Analytics pane.

 

Regards.
Pavel

Frequent Visitor

I am having the same issue....

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors