Skip to main content
Microsoft Idea

Power BI

Completed

ability to add trend line to charts

Vote (463) Share
Jordan Kline's profile image

Jordan Kline on 23 Jan 2015 07:42:00

It would be great if we could toggle on and off a trend line for line and bar charts

Comments (99)
Jordan Kline's profile image Profile Picture

Anonymous on 05 Jul 2020 22:54:04

RE: ability to add trend line to charts

It would be nice if you could do add a function to do a basic linear prediction based on a simple linear regression. Hopefully, it could be use with R so, it's an extension of a trend line into the future, but not necessarily a forecast (giving weight to time order).

Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 22:51:38

RE: ability to add trend line to charts

this is not completed, unless you want trends only for continuous variables (which is not very common or useful)

Jordan Kline's profile image Profile Picture

Simon Hetzel on 05 Jul 2020 22:30:29

RE: ability to add trend line to charts

Also whilst we can do trend line per series we cannot add min/max/avg lines per series

Jordan Kline's profile image Profile Picture

dung-anh on 05 Jul 2020 22:29:35

RE: ability to add trend line to charts

please re-open this one, it's not at all complete... we stuck with the "categorical" type..

Jordan Kline's profile image Profile Picture

Bill logsdon on 05 Jul 2020 22:28:44

RE: ability to add trend line to charts

This also is a major feature of both Spotfire and Tableau. Its as simple as right clicking and choosing which type of curve fitting you want to do (straight line, exponential decline, power curve, etc.) Even better is the ability to generate a calculated value based on the fitted curve and save that value to the data set.

Jordan Kline's profile image Profile Picture

Paul Caelen on 05 Jul 2020 22:26:09

RE: ability to add trend line to charts

The trend line option added is useless, because the can only use it in some modes. Alse it can not be used when the x-axis is set on type; continuous and scale; lineair.

Jordan Kline's profile image Profile Picture

Jon Culp on 05 Jul 2020 22:26:03

RE: ability to add trend line to charts

This is not completed. This should be reopened.

Jordan Kline's profile image Profile Picture

Power BI User on 05 Jul 2020 22:24:55

RE: ability to add trend line to charts

I would like to see this same trend line options as excel

Jordan Kline's profile image Profile Picture

PaulK on 05 Jul 2020 22:23:48

RE: ability to add trend line to charts

Hi All,

Seems Microsoft added linear trend lines and closed this idea out. I've added a new idea request for advanced trend lines. Please go vote/comment for it here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14831643-advanced-trend-lines-in-charts-polynomial-expone

Jordan Kline's profile image Profile Picture

PaulK on 05 Jul 2020 22:23:48

RE: ability to add trend line to charts

I would really like trend line options other than linear. Exponential or polynomial would be fantastic!