Add a trend line to a line chart Power BI 2024

[jstnm]

Hello,

I have a line chart and I need to add a trend line to it, all the posts I can find on here are on an old version of Power BI (thats why I put the year in the subject).  Those old ones all have a trand line option in the analytics part of their program, but that is no longer the case:

Does anybody know how to add a trend line in a current version of Power BI? Version 2.123.742.0

[gmsamborn · Accepted solution]

Hi @jstnm  @YG0n 

In addition to the comments by @v-xuxinyi-msft , a continuous axis has a couple of rules.

A continuous axis must be a number preferably with no gaps.

Usable Numeric examples include:
Date (dates are stored as numbers)
Year
Week of Year, Month of Year, Quarter of Year, etc ONLY for a single year otherwise totalling by [Week of Year] for example would include that week for all selected years

NOT Usable Non-numeric examples include:
Month name
Quarter
any column like [Yr-Mon], [Yr-Qtr], [Yr-Week]
also columns [Yr-Mon Number], [Yr-Qtr Number], [Yr-Week Number] because of gaps.

While trend lines can be used with Years (over a long period of time),  they are usually used with Dates as well as a few other numeric examples when showing a single year.

[jstnm]

My X-axis is set to continuous:

It is using a Date column:

The data type for the date column is Date:

I still have no option for a trend line under further analysis:

[YG0n]

I have the exact same issue

[v-xuxinyi-msft]

Hi @jstnm 

Thanks @samratpbi  for your timely reply. Here is my testing:

My version:

First the X-axis Type needs to be "Continuous", not "Categorical".

Then you can open the "Trend line" under "Further analyses".

If the type of the x-axis is ”Categorical“, there's no such option.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[samratpbi]

Hi, I am in Feb 24 version and I can see this in a line chart. Are you looking for the same?

If this resolves your problem, then please mark it as Solution, Thanks!

[jstnm]

What version number are you on? This is what mine looks like for Line Chart:

I do not have the option for trend lines anywhere in these blades.