Forum Discussion
Do not Summarize not working.
I hate saying does not work. I am in the IT field I can normally figure these things out. I looked online for 2 hours before posting. Nothing seems to work.
My problem is that I have a column that is ALWAYS being aggregated even when "Do no Summarize" is on. There seems to be no way for the graph to display the way I want.
And another pic.
Why can't I just display the data that is in the reult column? No aggregate. No summary. No anything. IS it too many values? Please help before I rip my hair out.
For this visual, Power BI will generate an internal query table that is the summary of the Value field, for each combination of the fields used in the Axis and Legend. If that is already the lowest level of detail in your data, then an Average or Sum aggregation will give you the result you are after.
If not then please clarify what you expect, with some sample data.
2 Replies
- mike_honeyMemorable Member
For this visual, Power BI will generate an internal query table that is the summary of the Value field, for each combination of the fields used in the Axis and Legend. If that is already the lowest level of detail in your data, then an Average or Sum aggregation will give you the result you are after.
If not then please clarify what you expect, with some sample data.
- BlahManNew Member
What a silly mistake on my part. Thanks!