Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Scatter Plot - Like Excel

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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