Forum Discussion

BlahMan's avatar
BlahMan
New Member
9 years ago
Solved

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. 

myProblem

And another pic. 

MyProblem2

 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_honey's avatar
    mike_honey
    Memorable 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.

    • BlahMan's avatar
      BlahMan
      New Member

      What a silly mistake on my part. Thanks!