Trend line - R2, slope and interception

[Anonymous]

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. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have foud a similar post, please refer to it to see if it helps you.

How can I display the slope and y intercept of the... - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.