Skip to main content
Microsoft Idea

Power BI

Needs Votes

Advanced trend lines in charts (polynomial, exponential,...)

Vote (740) Share
PaulK's profile image

PaulK on 16 Jun 2016 21:59:12

Thank you for adding the linear trend line, however Power BI would be much more powerful with additional trend line functionality. We would love to see advanced options such as polynomial, exponential and logarithmic trend lines.

Essentially the trend line functionality from excel would be perfect

Comments (58)
PaulK's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:29:44

RE: Advanced trend lines in charts (polynomial, exponential,...)

A lot of suggestions like this one (conditional formatting for matrices being another example) amount to requests that Microsoft make Power BI more like Excel. One has to wonder whether more effort ought to be put into making Excel work with Power BI than into duplicating Excel's features in Power BI.

PaulK's profile image Profile Picture

CLAYTON on 05 Jul 2020 22:28:02

RE: Advanced trend lines in charts (polynomial, exponential,...)

moving average, ability to toggle # of periods, and smoothed lines please!

PaulK's profile image Profile Picture

Power BI User on 05 Jul 2020 22:27:41

RE: Advanced trend lines in charts (polynomial, exponential,...)

KIND OF FINANCIAL TREND LINES MAY BE INCREDIBLY USEFUL LIKE MOVING AVERAGE, FORECASTING, ETC.

PaulK's profile image Profile Picture

bhagawat rawat on 05 Jul 2020 22:27:18

RE: Advanced trend lines in charts (polynomial, exponential,...)

Also, if the features such as R-square value, slope etc are displayed (on the line, tabular form, sort-able etc)

PaulK's profile image Profile Picture

Power BI User on 05 Jul 2020 22:27:17

RE: Advanced trend lines in charts (polynomial, exponential,...)

Like to show trendline into future

PaulK's profile image Profile Picture

Andrzej Hladki on 05 Jul 2020 22:26:30

RE: Advanced trend lines in charts (polynomial, exponential,...)

I'd love to see all coefficients for trends, a bit more numbers in this exploratory analysis please :)

PaulK's profile image Profile Picture

EYMARD on 05 Jul 2020 22:26:02

RE: Advanced trend lines in charts (polynomial, exponential,...)

Hello,
Casey said that it is possible to add trend lines but how? Because I do not see this option in Lines charts (only in Scatter chart).

PaulK's profile image Profile Picture

Casey on 05 Jul 2020 22:25:41

RE: Advanced trend lines in charts (polynomial, exponential,...)

The trend line feature that was recently added is great and much appreciated, but it would really create so much more value to have more advanced features like those mentioned above.

Could we also have the option of displaying the R2 or other correlation value? And the fit line equation. Even if the equation couldn't be displayed on the report, it would be nice to be able to see what it is (and copy the text for use elsewhere)