Advanced trend lines in charts (polynomial, exponential,...)
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
Really need the exponential line!!! And confidence band.
Please notice your main competitor, Tableau, has this attribute and please catch up...
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.
Seth Werner commented
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.
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!
Christina Williams commented
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
Jorge Segarra commented
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.
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!
It's actually pretty ridiculous that this hasn't been incorporated yet. This is a simple and essential feature for visuals.
Very much required! Wondering why it is not yet in...
Stuart Cary commented
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.
This would be a super addition, and I'm surprised that it's not yet been developed. Here's to hoping that this gains some traction.
Really need this for continued use of the program
Is there an ETA for this feature ? The addition of these trendline would be very helpful as well as the formula, R2, forcast period too.
David Holland commented
In addition to this, it would be useful if you could add trendlines to the combo visual (line and column/bar) for the line on the second Y-axis. I recently added a 30 day moving average line to a line and stacked column visual in power bi by using DAX measures but carrying out the same functionality in Excel is a couple of clicks (add trendline, change period to 30 days).
I recall this feature being added in September 2016 and I was using it as recently as March 2017. Then, sometime after that 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?
Jeremy Herbert commented
Please, please, please recreate the trend line functionality we have for charts in Excel. Would love to have a moving average or polynomial option (as would our users)!
The trend line option is good but it could be better ! Now it is too basic, maybe more options as "Show trend equation" and options of trend line calculation (exponential, polynomial...)
[I am using Power BI last release on 4th January,2018.
What's more, I am french so my text can hide some mistakes]