cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Benj Frequent Visitor
Frequent Visitor

Trend Lines

Is it possible to add trendlines to a scatter graph, like you can in Excel.

 

One example would be adding a linear trendline and being able to see the equation to get correlation coefficients.

 

Another example would just be to add a linear/exponential etc. trendline to a time series graph, giving the ability to project forward in time.

 

Thanks

 

Benj

32 REPLIES 32
Super User
Super User

Re: Trend Lines

I am not aware of that capability, you can check out the custom visual gallery or check Ideas section.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
Super User
Super User

Re: Trend Lines

included in the latest awesomness: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-update-feature-summary/

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Super User
Super User

Re: Trend Lines

Nice one @ImkeF, I just found that today and was planning on updating my oh-so-dated knowledge!


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

DouglasAPlummer Frequent Visitor
Frequent Visitor

Re: Trend Lines

Anyone NOT having trend lines options show after the update for all type expected?

 

Note says " data in the following charts: line, scatter, bubble, column, area, and combo charts" and I have in scatter. But for a column or line chart no "Trend Line" as expected from the release notes and video.

 

Column chart options below.

 

Capture.PNG

Super User
Super User

Re: Trend Lines

It is the Clustered Column Chart that has it, not the Stacked. And for Line Chart and Clustered Column Chart, make sure that your X-Axis is set to "Continuous" and not "Categorical"


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User
Super User

Re: Trend Lines

@DouglasAPlummer Looks like it is also dependent on what field you are using in your x-axis. If you look closely in the video in the two examples, one is using time, the other a numeric value. I just tested this out and it didn't show up as a formatting option till I used one of those. (or, not a text field). Put another way, it needs an x-axis that it can actually draw a trend on.


Near SE WI? Join our PUG Milwaukee Brew City PUG
DouglasAPlummer Frequent Visitor
Frequent Visitor

Re: Trend Lines

thank (again). Being able to do when categorical would be nice but this is a step in the right direction.

Sean Super Contributor
Super Contributor

Re: Trend Lines

@Seth_C_Bauer is absolutely right!

 

even your standard YYYY-MM is unfortunately but understandably not recognized

 

You have to start with a Date Column and then just keep Year and Month.

 

Month Numbers only - work though.

 

KHorseman Super Contributor
Super Contributor

Re: Trend Lines

So anyone who needs weekly trends is out of luck?


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)