Forum Discussion
Clustered Column Chart and Trend Line
have you considered creating your own trend line (with LINESTX) and add it to the chart?
Hi Power_It_Up ,
- 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).
- Set this column as the X-axis and change the axis type to Continuous.
- 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.
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.