Forum Discussion
Add average numbers as benchmark onto scatter plot
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.
Hi Zoe dax ,
Thanks for your reply! I included screenshots of the expected output and a fake dataset, can you be more specific on what you need to be clarified?
Basically it is a scatter chart that has sales as an x-axis and margin % as a y-axis. I would like to plot both the data (by product) for a specific company, as well as the average (by product) of all companies, in two different colours identified by a legend (Customer A, Industry Average).
I am predicting that there will be another problem when it comes to the average because its currently being automatically calculated by Power BI when I make a table with the columns: Product, % Margin, $ Net Sales, as these are measures. When you add the dimension of customers, you get the customer level data that is currently plotted, by I want an added dimension that compares it to the average.
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.