Forum Discussion
Alicia_Anderson
Resolver I
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 n...
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.
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