"Do not summarize" missing

I am trying to build a bubble scatter chart with a field (in this case, a non-additive ratio) I do not want to aggregate. However, Power BI seems to default to summing this field, but I do not want ...

Need Help

Anonymous

Not applicable

10 years ago

Unfortunately, this is not working for me. I have two fields in my data set that I wish to scatter plot. One field is "population", the other "number of injuries". Both fields are whole numbers. The population field represents the population of a given state, such as California. Regardless of the data being presented in the scatter plot, the population remains the same. Therefore, I do not want to aggregate it.

In the scatter plot, I do not want to aggregate the population field. I have set the Default Summarization = "Do not summarize". However, when I place this field on the Y-axis within the scatter plot, it continues to "Sum" the values in "population".

Furthermore, "Do not summarize" is not appearing as an aggregation option.

I'm likely missing something obvious, but in a scatter plot, you often do not want to aggregate an axis, depending on the nature of the data. It's a bit frustrating to produce something so very simple.

Any ideas are welcome.