Clustered Column Chart and Trend Line

[Power_It_Up]

Hi.

I have spent a whole day researching this problem and still can't figure out a way to add a trend line for month/year.  Have tried normal date, hierarchy date, I have converted months to numerics but still nothing.

This is what I have for a clustered column chart with month and year added and at the top level (perfect):-

I drill down to month and (where's my line gone and continuous setting has disappeared):-

I have used MONTH([Start Date]) and YEAR([Start Date]) as the X-Axis and they are both set to whole number.

Help would be greatly appreciated. 🙂

Thank you.

[lbendlin · Accepted solution]

have you considered creating your own trend line (with LINESTX) and add it to the chart?

[V-yubandi-msft]

Hi @Power_It_Up ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @Power_It_Up ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft · Accepted solution]

Hi @Power_It_Up ,

1. To add a trend line for Month/Year in Power BI, link a Date Table to your data and create a combined Month-Year column (e.g., Jan 2025).
2. Set this column as the X-axis and change the axis type to Continuous.
3. Use a Line and Clustered Column Chart and enable the Trend Line in the Analytics Pane.

@lbendlin , suggested creating a trend line with LINESTX, which is good option for custom calculations. Both methods work well based on your needs.

I also found a similar thread in the community that might help worth checking out.

Solved: Trend Line to Column Chart - Microsoft Fabric Community

Solved: Trendlines on clustered column chart - Microsoft Fabric Community

Solved: Column Chart/Trend Line - Microsoft Fabric Community

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

[lbendlin · Accepted solution]

have you considered creating your own trend line (with LINESTX) and add it to the chart?

[Power_It_Up]

Yes, I have been looking at this also. 👍