Is there a way to add a trend line to a line and clustered chart?

[gbarr12345]

Hi there,

I have a quick question (may seem like a dumb question) but is there a way to add a trend line to a line like an average line and clustered chart?

I don't see an option for it in the further analysis area.

[Anonymous · Accepted solution]

Thanks for the reply from @rajendraongole1 and@Uzi2019 , please allow me to provide another insight: 

Hi  @gbarr12345 ,

According to the official documentation: dynamic lines do not support line and clustered charts, and average lines are a type of dynamic lines.

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn

If you want to display a trend line in a line and clustered chart with year + month on the x-axis, you can try changing the data type of the [date] column to "Date", and then formatting the field as " YYYYY-MM".

In the Format pane, set the type to "Continuous" instead of "Categorical".

For a more detailed explanation, you can see the following link：

How to get trend lines in a date hiearchy? - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: Trendline no longer available when going the a low... - Microsoft Fabric Community

Solved: Month Year Trend Line - Microsoft Fabric Community

Best Regards,

Liu Yang

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

[gbarr12345]

Hi Liu,

Apologies for the delayed response. I was out of office for the last 2 weeks.

I set the date format to YYYY-MM as you mentioned above.

However, I still can't see an option to change the type to continuous:

This date field seems to have been created manually so is this possibly why this is the case?

[rajendraongole1]

Hi @gbarr12345 - Analytics pane is not avialable now in Line and clustered chart in latest release 2024 june.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[gbarr12345]

Hi Rajanedra,

Apologies for the delayed response. I was out of office for the last 2 weeks.

Thanks for the information. Would you know if it might possibly be introduced at some stage in the near future?

[Uzi2019]

Hi @gbarr12345 

Try this video 

https://www.youtube.com/watch?v=KoUzUm0M0ZY

https://www.youtube.com/watch?v=vQaoJFL3l40

Ihope I answered your question!

[gbarr12345]

Hi Uzi,

Apologies for the delayed response. I was out of office for the last 2 weeks.

Thanks for the videos, I'll give them a look and hopefully they help.

Many thanks.