Skip to main content

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 (91)
Jordan Kline's profile image Profile Picture

6f0d2483 d049-49a5-aebc-099976d34748 on 05 Jul 2020 23:02:02

RE: ability to add trend line to charts

Please re-open this one, It would be helpful if the existing scatter chart provide trend line as polynomial, logarithmic, exponential

Jordan Kline's profile image Profile Picture

523430b1 2734-4de7-b847-840a993fff70 on 05 Jul 2020 22:57:09

RE: ability to add trend line to charts

It would be more powerful if the existing scatter chart provide trend line beyond linear trend, such as polynomial, logarithmic, exponential

Jordan Kline's profile image Profile Picture

dbd7962f e048-4e02-abf6-4ec7a6076b4b 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

067e180b 4e6a-418a-bf3e-8b6c3b5c6820 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

02c4f7cf ca19-4cce-bb2d-0caf3cd2347c 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

218e0ddb 0d54-4fe0-80f9-140320fc437c 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

193c923d 46c9-48f7-945d-45b50befced2 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

9694fbc4 cb61-4e18-ad59-924db66b46fa 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

2eb972b4 52bf-45b5-bbc1-8efac21b90c6 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

fe2a2d23 9f46-4aaa-a0a1-68ebaa95d6de 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