Forum Discussion

Giorgi1989's avatar
Giorgi1989
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Adding a third calculated measure to Scatter Plot

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...
help needed
Help Request
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    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

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

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