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 ,
- 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.