Skip to main content

Power BI

Needs Votes

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

Vote (510) 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 (45)
PaulK's profile image Profile Picture

c2bf67a0 affc-41a3-8734-e4e881368bda on 06 Jul 2020 00:10:14

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

This is a mandatory feature for any BI tool. Stop working on other random features and focus on core analysis tools please PBI team.

PaulK's profile image Profile Picture

23bb6895 d59a-4cbb-92cc-19d4d2913dda on 06 Jul 2020 00:06:10

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

I was actually quite surprised that this was not included already. Please add polynomial trend line at the very least.

PaulK's profile image Profile Picture

fd9ce38c 0069-445f-9cc9-0e965e7099b9 on 06 Jul 2020 00:05:28

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

using a measure as a trendline would be awesome!

PaulK's profile image Profile Picture

9ea3797e b925-41ae-9b76-73e441274949 on 06 Jul 2020 00:02:20

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

Would love a 2nd-order polynomial trendline for scatter graphs. As others have mentioned; it's already available in Excel and would make a great addition to PowerBI

PaulK's profile image Profile Picture

1de6390d 0815-4f95-8550-3c29d5b841ca on 06 Jul 2020 00:01:30

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

This would be quite handy - I am transitioning users from excel to pbi and they have several charts that have polynomial smoothing trend lines and the best I can currently offer them thru dax is a chunky looking moving average line

PaulK's profile image Profile Picture

1656833f 908a-43a4-9013-96d9c28e38c2 on 05 Jul 2020 23:56:06

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

Really need the exponential line!!! And confidence band.
Please notice your main competitor, Tableau, has this attribute and please catch up...

PaulK's profile image Profile Picture

f9987011 1efa-4b6f-9a21-f2bf577be668 on 05 Jul 2020 23:55:58

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

Yes, being Power BI as an advance reporting tool it should have advanced trend lines feature. I am really looking for Polynomial trend line in it.

PaulK's profile image Profile Picture

10a6864e 4489-4e93-901f-71a419431708 on 05 Jul 2020 23:54:03

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

You should be able to toggle trend lines for an individual series in a graph. The current "Combine Series" toggle is an all-or-nothing solution. It doesn't allow you to show a trend line for one value, but hide it for another. This needs to be fixed.

PaulK's profile image Profile Picture

6464ef5c 2926-4956-810f-70e088f343d0 on 05 Jul 2020 23:53:20

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

This would be great for those who are coming from Excel. However R is a much more powerful tool that has already been integrated into Power BI. Maybe the people just like having options!

PaulK's profile image Profile Picture

e121e3db 4af4-4379-92e0-7b4ee44c5b1c on 05 Jul 2020 23:47:57

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

It is a must with our work, and the only reason for why I still have to work on certain charts within Excel instead of Power BI