Forum Discussion
Scatter plot, trend line and R-squared value
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
4 Replies
- DavidPROVOST
Advocate III
You can now do this with new function LINEST
- vanessafvg
Community Champion
oh cool I will check it out.
- Greg_Deckler
Community Champion
The different analytics lines kind of come and go as they please. I've never seen an R-squared analytic line.
- vanessafvg
Community Champion
elyfiora i dont think you can do that it probably needs to be either or