Adding a third calculated measure to Scatter Plot

[Giorgi1989]

Dear All,

I am using a scatter chart, whereby as 'Values' I use customers, as X Axis 'Profits', and as Y Axis 'Net Sales'.

I want do add a third calculated measure (Avg. Profits % for Product Category) to X Axis. 

In the end, I would want to see both the 'Profits' for the particular customer and the average profits for the corresponding product groups. 

Any help, suggestion, or tip would be greatly appreciated.

Have a wonderful weekend!

[v-cazheng-msft · Accepted solution]

Hi @Giorgi1989 ，

Just as amitchandak said, you couldn’t use two Measures on x-axis, otherwise, you will receive the following error. To make this visual display properly, you need regulate fields as the error prompted.

Per the description, create the Scatter chart like the following would be a good choice.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[amitchandak]

@Giorgi1989 , You can not use 2 measures on x-axis , but you can use one as a size