Scatter plot, trend line and R-squared value

[elyfiora]

Hello,

I'm performing a scatter plot on Power BI Desktop with X axis, Y axis, Legend and Size values.

I noticed that into analytics panel the trend line is not available (I can select only X-Axis and Y-Axis constant line, min and max line, average line, symmetry shading and ratio line).

If I remove size into scatter plot the trend line becomes available.

Is there any possibility to show the trend line even if I add size info scatter plot ?

In addition is there the possibility to show the R-Squared value when the trend line is shown?

Thanks in advance for the collaboration

Elisa

[DavidPROVOST]

You can now do this with new function LINEST

[vanessafvg]

oh cool I will check it out.

[vanessafvg]

@elyfiora  i dont think you can do that it probably needs to be either or

[Greg_Deckler]

The different analytics lines kind of come and go as they please. I've never seen an R-squared analytic line.