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