Forum Discussion
Resolver IMissing Trend Line and Forecast options in Analytics
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.
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.
22 Replies
v-frfei-msftCommunity Support
Hi Alicia_Anderson,
Do you have a date field on the Axis? Forecast will only appear when using a date there.
Regards,
Frank
- 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_AndersonThe 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.
You wanna make sure that your X-axis type selected is "continuous". That fixes the problem for the Line chart.
that is correct.
wbhiteHelper I
I can confirm that the Forecast and Trend options are missing for all visuals in the March 2019 update.
- Greg_Deckler
Community Champion
Sometimes that is caused by not having enough points.
- Alicia_Anderson
This is what I see.
- tarunsingla
Solution Sage
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
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
Any update on this?
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.
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.
