Forum Discussion
Add average numbers as benchmark onto scatter plot
Hi, I need help with adding a second series of data to my scatter plot. I am currently plotting Sales vs. Margin % by Customer and would like to add the averages of all customers as another serie...
Hi Anonymous ,
Based on my test, I find that the scatter chart seems not support multiple metrics in chart(can't use two measures in same axis of chart). It seems that it could use calculated columns in same axis. So I think you might need to create summary table which store sale and margin % as columns.
By the way, you also could submit this in power-bi-ideas .
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not sure if images were correctly added to the post: