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
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]
I agree with this post, this would be a quick and easy fix!
Imke Feldmann commented
while this is still open, I've posted a very basic version Excel-TREND-function for PBI here: http://community.powerbi.com/t5/Desktop/Formula-for-trendline/m-p/86449/highlight/false#M36271 (can toggle number of Intervalls, but no individual slope and intercept)
A lot of suggestions like this one (conditional formatting for matrices being another example) amount to requests that Microsoft make Power BI more like Excel. One has to wonder whether more effort ought to be put into making Excel work with Power BI than into duplicating Excel's features in Power BI.
moving average, ability to toggle # of periods, and smoothed lines please!
KIND OF FINANCIAL TREND LINES MAY BE INCREDIBLY USEFUL LIKE MOVING AVERAGE, FORECASTING, ETC.
bhagawat rawat commented
Also, if the features such as R-square value, slope etc are displayed (on the line, tabular form, sort-able etc)
Like to show trendline into future
Andrzej Hladki commented
I'd love to see all coefficients for trends, a bit more numbers in this exploratory analysis please :)
Casey said that it is possible to add trend lines but how? Because I do not see this option in Lines charts (only in Scatter chart).
The trend line feature that was recently added is great and much appreciated, but it would really create so much more value to have more advanced features like those mentioned above.
Could we also have the option of displaying the R2 or other correlation value? And the fit line equation. Even if the equation couldn't be displayed on the report, it would be nice to be able to see what it is (and copy the text for use elsewhere)