Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

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

Seth Werner 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

Dannel 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

Christina Williams 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

PaulK's profile image Profile Picture

Jorge Segarra Rovira on 05 Jul 2020 23:47:23

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

This is really critical functionality especially for oil and gas customers who do this sort of analysis on a daily basis quickly and easily with other toolsets.

PaulK's profile image Profile Picture

Guido on 05 Jul 2020 23:46:02

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

Yes, please.

PaulK's profile image Profile Picture

Power BI User on 05 Jul 2020 23:43:11

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

Yes, please!

PaulK's profile image Profile Picture

Sheepie on 05 Jul 2020 23:41:41

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

PLEASE make this work!
I need to be able to plot usage per tonne against total production and show current month vs the trendline (which is not linear!). Without this ability I can't progress with production reports.
Even SAP BW (circa 2004) can do this!

PaulK's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:28

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

It's actually pretty ridiculous that this hasn't been incorporated yet. This is a simple and essential feature for visuals.

PaulK's profile image Profile Picture

Jani on 05 Jul 2020 23:40:17

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

Very much required! Wondering why it is not yet in...

PaulK's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:40:00

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

Is this on road map or backlog? Seems odd that Power BI is incorporating a ton of advanced A.I. features but still does not support this feature yet.