Forum Discussion

Benj's avatar
Benj
New Member
10 years ago

Trend Lines

Is it possible to add trendlines to a scatter graph, like you can in Excel.   One example would be adding a linear trendline and being able to see the equation to get correlation coefficients.   ...
HediSlim's avatar
HediSlim
Frequent Visitor
9 years ago

Hello Benj,

 

I have the same need about trend lines equations. 

 

Did you get any responses since ?

Maybe is there a DAX formula which could heps us ?

 

Best regards

willz06jw's avatar
willz06jw
Helper II
9 years ago

Currently, as of version 2.47.4766.801 64-bit June,2017 (and perhaps before), you can use a Date field, but NOT a Date Hierarchy to display trend lines.  

You change this by:

1.  Changing the 'Modeling'/'Data type' on your field to 'Date' in the 'Data' area (far left)

2.  In 'Report' area (far left), select the object which needs to have the trend line

3.  Add the Date as the Shared Axis (if using Line and Clustered Column Chart)

4.  In the 'Fields' for the object, click the down arrow next to your Date shared axis

5.  Select the field's name, and NOT Date Heirarchy

6.  Click 'Analytics' and 'Trend Line' is suddenly available