Trendline needed

[ArchStanton]

I have a simple linechart with MonthName on the x-axis (this is derived from my own custom built calendar going from Apr to Mar as per Financial Year) and a DISTINCTCOUNT Measure of IDs for the Y axis, I would like to add a Trendline.

I do not see the option at all when using the Line Chart or Clustered Column chart: 

Can anyone help? Thjis should be easy to do, its very frustrating!

Thanks

[nleuck_101]

@eng23 

Can you screenshot your measure?

[eng23]

Yes,

[nleuck_101]

@eng23 

It looks like you're using a measure at the Intercept + Slope * measure in the RETURN section. You want to use your column [Progress_date] not a measure.

[eng23]

ok , but may I ask why there is the red line under my [Slope1] and [intercept]? thanks..

[nleuck_101]

@eng23 

When you use LINEST or LINESTX it creates a single row with ten columns. In the measure that I provided we are creating a variable using LINESTX. The red lines under [Slope1] and [Intercept] is becasue it doesn't recognize those as columns until you've finished creating the measure. Those variables get calculated in order from top to bottom.

[nleuck_101]

@ArchStanton 
I have the same thing with mine but it works just fine.

[ArchStanton]

 with same Y Axis set at Zero:

[ArchStanton]

Thanks, I've finally got it to work 😊

I've notice the trendline is far steeper with your Variable (see solid line in top line graph) compared to when I use the inbuilt Trendline using the Continuous x Axis date range. This inbuilt range has every other month missing which is why I'm desperate for an alternative option.

I guess I need to decide which one to use. My only other option is to Snip an image of the the x axis with complete months and paste them over in Powerpoint when this get presented, incredible we still have to do this in 2023!

Thanks for all of your help!

[nleuck_101 · Accepted solution]

@ArchStanton 

I would think they would be the same line.

[ArchStanton]

as per screenshot, one is far steeper than the other. Its fine though, I can use either

[ArchStanton]

Thanks for helping me with this, much appreciated!

[amitchandak]

@ArchStanton , Click on the first icon.