Skip to main content

Power BI

Needs Votes

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

Vote (744) 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

ArtieFischer on 05 Jul 2020 23:20:45

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

This would be a super addition, and I'm surprised that it's not yet been developed. Here's to hoping that this gains some traction.

PaulK's profile image Profile Picture

carter on 05 Jul 2020 23:18:18

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

Really need this for continued use of the program

PaulK's profile image Profile Picture

Mélisa Blouin on 05 Jul 2020 23:14:34

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

Is there an ETA for this feature ? The addition of these trendline would be very helpful as well as the formula, R2, forcast period too.

PaulK's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:36

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

Must have

PaulK's profile image Profile Picture

David Holland on 05 Jul 2020 23:13:21

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

In addition to this, it would be useful if you could add trendlines to the combo visual (line and column/bar) for the line on the second Y-axis. I recently added a 30 day moving average line to a line and stacked column visual in power bi by using DAX measures but carrying out the same functionality in Excel is a couple of clicks (add trendline, change period to 30 days).

PaulK's profile image Profile Picture

Tom on 05 Jul 2020 23:10:44

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

I recall this feature being added in September 2016 and I was using it as recently as March 2017. Then, sometime after that the functionality was taken out. It doesn't seem to be there in the January 2018 build. Can anyone offer insight into if/ when this feature will be reintroduced?

PaulK's profile image Profile Picture

Jeremy Herbert on 05 Jul 2020 23:09:54

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

Please, please, please recreate the trend line functionality we have for charts in Excel. Would love to have a moving average or polynomial option (as would our users)!

PaulK's profile image Profile Picture

Thierry on 05 Jul 2020 23:08:43

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

The trend line option is good but it could be better ! Now it is too basic, maybe more options as "Show trend equation" and options of trend line calculation (exponential, polynomial...)

[I am using Power BI last release on 4th January,2018.
What's more, I am french so my text can hide some mistakes]

PaulK's profile image Profile Picture

Anonymous on 05 Jul 2020 22:59:29

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

I agree with this post, this would be a quick and easy fix!

PaulK's profile image Profile Picture

Imke Feldmann on 05 Jul 2020 22:33:45

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

while this is still open, I've posted a very basic version Excel-TREND-function for PBI here: http://community.powerbi.com/t5/Desktop/Formula-for-trendline/m-p/86449/highlight/false#M36271 (can toggle number of Intervalls, but no individual slope and intercept)