simple scatter plot?

[Anonymous]

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.

[Phil_Seamark]

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.