Forum Discussion
Alicia_Anderson
Resolver I
7 years agoMissing 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 n...
- Anonymous7 years ago
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.
v-frfei-msft
Community Support
7 years agoHi Alicia_Anderson,
Do you have a date field on the Axis? Forecast will only appear when using a date there.
Regards,
Frank
Anonymous
7 years agoNot applicable
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,