Forum Discussion
Don't Summarize Option
Hi everyone,
Why don't appear "Don't summarize" option on my bar chart graph? I looked at the old posts but I didn't find any solutions. Could u help me please, guys.
byilmaz089 Charts are intended to show the summarised data based on the dimensions (axis). So will have atleast count or count distinct group functions if you also use all text fields on the chart. If you don't want any summarization, then switch that visual to table where you can find that option "Do not summarize" and it will show row level detail.... there is no option doing that in Chart to show each bar for each row.... hope it is clear...
2 Replies
- PattemManohar
Community Champion
byilmaz089 Charts are intended to show the summarised data based on the dimensions (axis). So will have atleast count or count distinct group functions if you also use all text fields on the chart. If you don't want any summarization, then switch that visual to table where you can find that option "Do not summarize" and it will show row level detail.... there is no option doing that in Chart to show each bar for each row.... hope it is clear...
For the same reason that you can't write a measure where you refer to a naked column. You can't write Measure = TableName[ColumnName]. You have to write Measure = SUM(TableName[ColumnName]) or something like that. The Values section of a visual that is based on numeric aggregation has to actually do some kind of numeric aggregation. The length of the bar on a bar chart has to be based on an aggregated number. If the x-axis values can have more than one value in whatever field you're using for the y-axis, it has to summarize those values in some way in order to get a number to assign to the y-axis.
