Forum Discussion

yaman123's avatar
yaman123
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Add Trend Line to Column Chart with Categorical X Axis

Hi all,    Is there any way to add a trend line to a chart with categorical x axis? Or are there custom visuals which can do this? Its a bit strange you dont have the option to do this in power bi ...
Need Help
Show and Tell
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

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

 

elisebear08's avatar
elisebear08
New Member
4 years ago

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])?