Forum Discussion
Bug?: Line Chart Behavior When Plotting Data, Instead Seems to Plot Data Aggregation (Sum, Count)
Deruth58,
What result would like to get in Line chart when you choose “Don’t summarize” option for your column under Modeling ribbon. In this case, if you want to get same result as that in the last screenshot, just change Count to Sum aggregation function.
In addition, when you choose “Don’t summarize” option for your column under Modeling ribbon, it doesn't mean that you can get "Don't summarize" option in Line chart. The "Don't summarize" option is only available in Table visual.
Regards,
Lydia
Hi Lydia,
Thanks for your response, but I'm a bit confused. If you reread my post you'll see that to get the result shown in the last screenshot, I did in fact have to select "Sum" for the "Default Summarization" field on the Modeling tab. But to me that seems confusing and non-intuitive.
Maybe I'm just not understanding the meaning of "Default Summarization" and what that field does for the various available values in the pulldown menu (i.e., Don't summarize, Sum, Count, etc.). But to me it seems unintuitive.
I want a simple time plot of the data itself, NOT an aggregation (Sum or Count, for example) of the data. So to me, the intuitive choice to make for the "Default Summarization" pulldown menu on the Modeling tab would be "Don't summarize". To me, the choices of Sum or Count imply an aggregation of my data, which is not what I want.
Again, maybe I'm just misunderstanding some Power BI concept, but it seems like I'm not alone in finding this unintuitive, if the intended behaviour to get a basic time series plot is that one has to select "Sum" instead of "Don't summize".
Thanks,
Doug
Deruth58,
When you select "Don't summarize" for your field under Modeling tab, it doesn't impact the aggregation in Line chart. Because in line chart, bar chart and so on, there is no "Don't summarize" option, any data type of fields that are dragged into Values section of line chart will be aggregated by default.
If you need to use "Don't Summarize" in visual, please use table visual. Table visual has the "Don't summarize" option, in other words, even if you don't choose "Don't summarize" option for your numerical field under Modeling tab, you are able to use "Don't summarize" option in table visual to show actual data.
Regards,
Lydia