Polynomial Fit - Add data to create a polynomial fit line

[Anonymous]

Community,

I am curious if anyone has experience adding a calculated column (or any other means) that would be data that represents a polynomial fit to current data in a table.

In the example below, the blue line represents a few thousand points of data in the "CD" column and the red line is the polynomial fit of the "CD" data points. The graph was created in Excel, but I would like to have the capacity to complete this in Power BI.

Any thoughts on how to create the data to manufacture the red line?

Any help or direction to articles/information/blog posts would be appreciated.

[v-gizhi-msft]

Hi,

According to your description, i think your requirement can not be reached completely in Power BI, but i have a workaround.

Please try to use Scatter Chart visual, and add a trend line to this visual, it shows:

Hope this helps.

Best Regards,

Giotto Zhi

[Anonymous]

@v-gizhi-msft 

Thanks for the respones, but at this time the trendline is of no help.

[v-gizhi-msft]

Hi,

I think till now there is no such function like this in Power BI, but you can create an idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas 

It is a cool idea!

Best Regards,

Giotto Zhi