Why is the detail on my Scatter graph not working as I expected?

[HamidBee]

Hi,

I am trying to plot a scatter graph. Please see the data that I am working with below:

And this is how it plots:

When I add detail this is what I get:

As soon as I add detail the graph doesn't plot. Essentially I am aiming to add a cluster. 

Does anyone have any idea as to why the graph is not plotting as it should when I add details?

What type of details are accepted in Power BI?

Thanks

 

 

[CNENFRNL]

The error message is self-explanatory, x-axis and y-axis must be summarized when you use Details field. That's to say, scatter chart is a visulization of summarized table grouped by Details, aggreation operation is to summarize x- and y-axis.

[amitchandak]

@HamidBee , can share the error details. There is a link on the error for that. Please share in text format

[HamidBee · Accepted solution]

Yes this is the error:

Can't display this visual.

Remove Details to display x- and y-axis pairs. Alternatively, you can keep Details and set a summarization for x- and y axis.

It worked now. What I did was I summarized the values for X and Y. When I set details as places it grouped the values together and summed them up. So there now is one plot for London which is (56,132). The two london points were added together. Notice that there are now only 4 points instead of 6. 

 

[amitchandak]

@HamidBee , Make sure both X and Y of number datatype , else you will not be able to use details