Forum Discussion
Anonymous
10 years agoNot applicable
"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 ...
ankitpatira
Community Champion
10 years agoAnonymous It depends on which area of visual you're dropping that field into. Most of the visual will sum up filed if you have that field set as whole number. If you're using table or matrix then you will have option to 'Do not summarize' which will show you all the values but if you're using column or pie or scatter chart it make sense that you should not display individual values but sum of it.
So in your case if you're trying to put that field into Legend area (for example) then you need to go to Edit Queries -> select your field -> change data type to Text. This will let you display individual values in legend in scatter chart however if you have many values it will give error saying too many values.