Missing Trend Line and Forecast options in Analytics

[Alicia_Anderson]

I have the latest version of Power BI Desktop installed:  Version: 2.65.5313.1381 64-bit (December 2018).   I am working on a line and clustered column chart but Trend Line and Forecast options are not shown.  I only see:  Constanct Line, Min Lin, Max Line, Average Line, Median Line and Percentile Line.   

[akchandarana]

Was helping a colleague with this and we couldn't get Trend Line to appear in their simple scatter plot of OT $Dollars vs. Hours with the points plotted being the 12 months of a year.  Tried the suggestion of making it a Full Date instead of the Months, but that didn't work.  I finally got the Trend Line option to appear in the Analytics pane after removing the $Dollars they had put on the Size.

[matiasdaniel]

Hey,

I solved this problem by using a full date column on the x-axis (not month, noth year/month etc.). Make sure your date table is marked as a date table if you have one. Plese nothe, that the tendline can only be used on visuals listed below.

• Area chart
• Clustered column chart
• Line chart
• Line and clustered column chart
• Scatter chart
  
  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

[gdemelol]

You wanna make sure that your X-axis type selected is "continuous". That fixes the problem for the Line chart.

[fernandomoraes]

I'm facing the same problem. Can't solve it. I've tried many solutions (date, hierarchy and so on). Same graphs appears, some not. I didn't find a explicity documentation about that. 

[wbhite]

I can confirm that the Forecast and Trend options are missing for all visuals in the March 2019 update.

[Effi]

Any update on this?

[v-frfei-msft]

Hi @Alicia_Anderson,

Do you have a date field on the Axis? Forecast will only appear when using a date there.

Regards,

Frank

[Anonymous]

I'm having a similar issue, but I think it's because my dates are weekly, not daily.  The trend line is in the analysis bar for me to create, but it's now showing up.  Wondering if it's because of the gaps in my dates.  We only track this thing once a week.

[Anonymous]

Thank you for the comment. I change the axis value to date Hierarchy, expand to the timeline I need, and the Trend Line option appears!

Thank you,

[v-frfei-msft]

Hi @Alicia_Anderson,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[Alicia_Anderson]

The X axis displays a Sprint, which equates to a 2 week period.  I don't want the X axis to be a date, but I changed it to one to see if the Trend and Forecast options displayed but it still did not.     

[Anonymous]

I'm having the same issue.  I'm using a Line chart and my X-Axis has fiscal weeks (WK01, WK02, ...) and would like to keep it that way.

[Anonymous]

Having the same issue as well using line chart with date (month) in axis and values as values.  Is this a bug?

[Greg_Deckler]

Sometimes that is caused by not having enough points.

[Anonymous]

Thank you! I saw the Trend line and Forcast options when I drilled down on the graph.

[Alicia_Anderson]

This is what I see.

[RandyPgh]

In the Line Graph depicted by @Alicia_Anderson , three values are being displayed (3 lines). The Trend line will only be available if you have a single line depicted in the graph. Otherwise, the Trend algorithm does not know which of the three to use in showing trend or how you might want to combine the existing three lines to show trend (sum, average, ??). The visualization is currently limited to showing trend for a single line.

[Anonymous]

gotcha.  I did have just one line, but I had a filter on the date when I removed it, voila, trend line is back.  thought it was kind of weird, but I'll just chalk it up to 'I can keep going' and keep going 🙂

[tarunsingla]

Not all dynamic lines are available for all visualizations. Check this for the limitations:

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane#limitations

Regards,

Tarun

[Alicia_Anderson]

I understand that.  I already read that page.    I am having the same issue with cluster column chart and line chart.