how to get the function of the trend line of my scatter plot

[Anonymous]

Hi everyone,

I have this chart:

I want to get the function of the red trend line.

How can i get it?

Thanks

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

You can try this,

in excel:

in Power BI Desktop:

FYI:

Add a Linear Regression Trendline to an Excel Scatter Plot (online-tech-tips.com)

Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

How to Create Trend Line in Power BI Scatter Chart - YouTube

Best Regards,

Community Support Team _Tang

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

[Anonymous]

Ty vry much, the problem is that i have filters that affects my chart and the trend line changes a lot.

[daXtreme]

Well, you have to calculate it yourself in DAX.

[Anonymous]

which kind of graph i have to use to be able to put a measure inside my scater plot?. Because in the scater plot that i have in pbi it have only the values option, and i supose that is for only the bubles not a line.

[Anonymous]

Im going to search about this. Thanks