Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Trend line - R2, slope and interception

Hi all, 

 

I am trying to get R2, slope and intercept for my dynamic line chart with no sucess. Attached is a screenshot of my report. Yellow are the questions I would love to find out the answser.

 

Few important notes - on the Y axis, I have a field (under Variable). The X axis is a parameter under the ana table. The formula should change depending which Variable is selected (DelAssay, DelMAG or DelTotal) but also depending on the StabTemp slicer. Would be ideal if I can get that numbers either on the plot or as a separate table. Additinally, the prediction of the Y value based on the X value is also needed, but I guess if I know how to get slope and intercept, this should not pose a problem. 

 

Who would imagine that obtaining a simple regression formula will give so much headache in Power BI - or maybe it is just me.

 

Any help is appreciated. 

  

 

 

1 Reply