Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

simple scatter plot?

I'm at a loss.


I pulled a table from sharepoint and I simply want a scatter plot, with the X axis from one column, and the Y axis from another.


Power BI Desktop wants to sum the columns. Why won't it treat each data point independently?


So confused...


I was able to make a time-series line chart out of the same data (one of the input columns is the date), so apparently it can render data without summarizing it. It wasn't intuitive, but whatever.


For a scatter plot you need to decide the item you want to plot first. Eg. Product or region (any dimension really).

Once you have that, add that to Detail or Legend. The detail item can only have 2 numbers, one for each axis. Either of the numbers can be an aggregate such as SUM, AVG or MAX/MIN. But you need to boil down to a single number for each axis.

To learn more about DAX visit :

Proud to be a Datanaut!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors