"Do Not Summarize" missing from scatter graph

Question

I'm struggling to find a way to NOT summarise numerical data when plotting a scatter graph. I can see the option in Power BI web, but not in the desktop version. The data looks like

x = 1,2,3,4,5

y = 12.4, 11.9, 10, 7.3, 6

Power BI insists on aggergating, either by sum or count, the x and y values. I'm running the Feb 2016 verion 2.32.

Is there a way to get Power BI to treat the data correctly? Have I missed something, or is the feature still being developed?

Thanks

phil_seamark · Answer

So just to be clear, in your Power BI model, do you have the following set to "Do Not Summarize" and it's still not working for your scatter?&nbsp;&nbsp;&nbsp;&nbsp;

willsmithorg · Answer

Have you put the same field you put in 'X axis' in your 'Details' section of the scatter graph?&nbsp; I agree that it would be preferable to do scatter plots how Excel has done them for the last 10 years, but this workaround works for me.&nbsp;Not only that, but I can now choose the aggregation level, e.g. I can round my X value down to an integer, and use that for the 'details'.&nbsp; Now many X values are amalgamated to a single point, but if I set the X axis to 'average of ...' then it shows in the correct location, not at the rounded down location.&nbsp; This helps the tradeoff between seeing all your data, and getting a dense cloud of points when you have thousands of data points.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hassantm · Answer

Hi MrJolly,&nbsp;&nbsp;Yes, that's correct. &nbsp;Using the example "Financal Sample.xlsx" dataset from the PowerBI Desktop web site, if I wanted to plot the Manufacturing Price against the Month Number, there is no option to plot the raw values, even when I have&nbsp;set the columns to Do Not Summarize. &nbsp;Adding Product to the Details box doesn't change the aggregation either. &nbsp;&nbsp;&nbsp;This is true for both the 32 and 64 bit versions of Power BI Desktop. &nbsp;I see the same behavour for line charts as well. &nbsp;&nbsp;The web version has the option to not aggregate the values.&nbsp;Thanks&nbsp;H

kcantor · Answer

I am not sure why this is happening but as a workaround have you tried creating a measure to calculate the count and then using that on the scatter chart instead?

hassantm · Answer

I don't want to calculate anything. &nbsp;I'm just trying to plot X against Y in a scatter plot - no counting or aggregation of the values. &nbsp;I'm trying to show the invidual values and then I'll plot a marker for the mean and some limits. &nbsp;Hence the need to not summarize the data.&nbsp;H

Forum Discussion

"Do Not Summarize" missing from scatter graph

7 Replies

Related content

Option to choose "Don't Summarize" Missing. "Do not summarize" is not honored.

"Do not summarize" missing

"Do Not Summarize" for Parameter Values

Tabular Editor Scripting - "Do Not Summarize"

missing data