Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

scatter chart show value based on calculation

Hi, 

I have to create a scatter chart to shows the quadrants
x- axis range (0-9000)
y- axis range (0-8000)

and measure having values for x and y axis
XQ1 = 1968
XQ2 = 1480
XQ3 = 1178

XQ4 = 514

YQ1 = 2141
YQ2 = 1479
YQ3 = 1182

YQ4 = 271
So based on this measure the plot should be like 
Q1 = (XQ1,YQ1) 
Q2 = (XQ2,YQ2) 

Q3 = (XQ3,YQ3) 
Q4 = (XQ4,YQ4) 

is there any way to plot like this?

Need Help
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    Please create the table.

     

     

    Then create these measures.

     

    X_Points = SWITCH( MAX('Table'[Points]), "Q1", [XQ1], "Q2", [XQ2], "Q3", [XQ3], "Q4", [XQ4])
    Y_Points = SWITCH( MAX('Table'[Points]), "Q1", [YQ1], "Q2", [YQ2], "Q3", [YQ3], "Q4", [YQ4])

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    Please create the table.

     

     

    Then create these measures.

     

    X_Points = SWITCH( MAX('Table'[Points]), "Q1", [XQ1], "Q2", [XQ2], "Q3", [XQ3], "Q4", [XQ4])
    Y_Points = SWITCH( MAX('Table'[Points]), "Q1", [YQ1], "Q2", [YQ2], "Q3", [YQ3], "Q4", [YQ4])

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.