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

562cdde8 4a9f-442d-8f6c-427602728fa8 on 05 Jul 2020 23:24:13

RE: ability to add trend line to charts

this is NOT completed.

back to Tableau.

Jordan Kline's profile image Profile Picture

f020ab10 9c8f-44e6-ad84-f24a2ea17ea0 on 05 Jul 2020 23:24:05

RE: ability to add trend line to charts

Not completed as of 7/6/2018. The trend lines option only works if the x axis is numerical....that makes no sense. The intended functionality is for any type of axis type. So, dates should work whether Jan, Feb, Mar, or 1.18, 2.18, 3.18 etc...

This needs to be addressed in PBI for it to be useful.

Jordan Kline's profile image Profile Picture

4e8559fc 05f7-4163-8ed5-2a94fb425387 on 05 Jul 2020 23:15:41

RE: ability to add trend line to charts

Is the trend line based upon least squares? I also noticed that it seems to interpret missing data as 0 and thus the trend line is incorrect if some years are missing in the data. I am trying to compare data sets where some years are missing in some and not others but the trend is way off for those locations with many missing years.

Jordan Kline's profile image Profile Picture

f270bb12 5bff-465a-92c0-94cbd831ac20 on 05 Jul 2020 23:13:57

RE: ability to add trend line to charts

This is not completed

Jordan Kline's profile image Profile Picture

46289dd2 f827-4f52-b8dc-ae507df3a14c on 05 Jul 2020 23:13:42

RE: ability to add trend line to charts

Please can this be re-opened - we need more Trend Line and Moving Average options please - similar to the options available on Excel charts

Jordan Kline's profile image Profile Picture

c0495205 0f0e-4075-a17e-244f8efe853b on 05 Jul 2020 23:13:36

RE: ability to add trend line to charts

This is not completed. Trendline's need polynomial option

Jordan Kline's profile image Profile Picture

cfb2d39d 11a1-443f-9d8b-59bfb81fbc18 on 05 Jul 2020 23:10:42

RE: ability to add trend line to charts

I recall this feature being added in September 2016 and I was using it as recently as March 2017. Then, sometime after then 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?

Jordan Kline's profile image Profile Picture

432f8533 f6d6-4dab-8a66-952fb2195ab7 on 05 Jul 2020 23:05:39

RE: ability to add trend line to charts

Why has this idea been labeled as COMPLETED when it is still not available for bar and line charts in the November 2017 version?
All that's available is: constant, min, max, average, media and percentile.

Any ideas anybody?

Jordan Kline's profile image Profile Picture

c3b3060b b597-4e1d-b663-117aa18d2f0c on 05 Jul 2020 23:05:23

RE: ability to add trend line to charts

It is not just helpful, it is a requirement from my users to be able to switch from Tableau to Power BI

Jordan Kline's profile image Profile Picture

b1ab318c e409-4ad1-9268-8da2caa3f37c on 05 Jul 2020 23:04:47

RE: ability to add trend line to charts

It would indeed be very helpful if it was possible to add an exponential trendline to the existing scatter chart