Scatter plot summarizing data

[Lorput]

I am a new Power BI dsketop user.  Under properties, the default summarization of my Total Cost and Unit Cost are both set to Do Not Summarize.  However, my scatter plot (Total Cost on Y, Unit Cost on x) insists on summarizing the data - Sum, Average, Minimum, etc - but there is not an option for Do Not Summarize.  How can I fix this?  Thanks for your help!

[willsmithorg]

Take your x axis field and also drag it to "details".

This still does the aggregate, but for every unique value in the "details" field.  If "x axis" and "details" are the same column, you get a point for every unique value of the x axis.

[Anonymous]

Great, @willsmithorg !

I managed to "solve" this same issue based on your answer. But I add that in order to make it work, you should change the aggregation function in "x axis" from count or sum to MAX or MIN.

If you keep the count, the x axis will show the number of records of each value in the field, and that's not what we want to see. If you use MIN or MAX, considering that all the records of each group are the same, you will get the values you want for X axis.

I put "solved", because I don't consider this a real solution, but a workoroud.

This is great as a workaoround, but I think the tool should provide a better and more intuitive way of doing this.

Thanks!!

[cj_cuccaro]

I've tried your suggestions and I can't figure out how to generate a scatter plot without aggregation. The dataset is comprised of a datetime field and a decimal field. I want the dates to show along the x axis and the decimal score data along the y axis. How do I simply use the two values as cartesian coordinates and plot them on the x and y axis?

Thanks,
CJ

[cj_cuccaro]

I've tried your suggestions and I can't generate a scatter plot without aggregation. The dataset is comprised of a datetime field and a decimal field. I want the dates to show along the x axis and the decimal score data along the y axis. How do I simply use the two values as cartesian coordinates and plot them on the x and y axis?

Thanks,
CJ

[Greg_Deckler]

Scatter plot requires an aggregation for x and y axis and size. Sounds like you want individual values. Try putting a column into Legend that has unique values for each row and then set your aggregation to SUM in the scatter plot. x + nothing = x.

[Lorput · Accepted solution]

I think that did it!