Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

"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
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous Look in these 2 places... You will also not see this option if your DATA TYPE is TEXT

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Thanks, I will examine these 2 places. I am trying to NOT aggregate a field (which is a numeric ratio and should not be aggregated) which I want to display on the y-axis of a scatter/bubble chart.  The "Do not summarize" option is not available; I suspect I have a data type issue or am trying to NOT aggregate in a manner that does not make sense to do so.  I will play around with this and see what I can do.  

    • Anonymous's avatar
      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.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Anonymous - Can you post a screen shot of your scatter plot visual configuration in terms of what data is in the axis, values, etc? I am having difficulty understanding the exact requirement here in terms of what you are looking to solve and what you are trying to plot. Some sample data would be very helpful as well. If the population never changes regardless, perhaps try "Average" as the aggregation or perhaps Min or Max. So, average of 1000, 1000, and 1000 is 1000 as will be the aggregate answer of min and max aggregations.