Forum Discussion
Post PartisanAdd Trend Line to Column Chart with Categorical X Axis
Hi, yaman123
You need use line and clustered column chart visual to replace the clustered column chart visual.
So that you can put this measure to line value.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Partisan
Does this work with Count? My Y Axis is a count of a column. When i add the measure to the chart, it doesnt show as a trend line. Attached image
Community SupportHi, yaman123
Yes, the same applies. You need to replace the sum(sales) with count(id) in the original formula . If the problem is still not resolved, please share your sample pbix file for further research.
Best Regards,
Community Support Team _ Eason
When you say replace sum(sales) with count(id), do you mean in the estimated sales calculation? Instead of Sum, what if Actual Sales = SUM(Sales[Amount]) was Actual Sales = AVERAGE(Sales[Amount])?
