Scatter Plot - Like Excel

[Anonymous]

Hi

How do you create a scatter plot in Power BI working like it would in Excel, where the X and Y Axis are just columns from a table

E.g.

Couples Age with Say Partner 1 age on the X Axis and Partner 2 on the Y Axis and then the dots are essentially co-ordinates of the couples age

 

Seems like something that should be straight forward but Power BI always wants to Sum the numercial value I put in the X and Y Axis

[Anonymous]

ahh - doh

That's what I thought (and you're right, thanks) the data I'm using is fake and there's an outlier in one of the axis, which made me think it was summing, plus the dots just fill out to look like a bar

[AlexisOlson · Accepted solution]

You can set both axes to "Don't summarize".