Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BlahMan
New Member

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.

1 ACCEPTED SOLUTION
mike_honey
Memorable Member
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.

View solution in original post

2 REPLIES 2
mike_honey
Memorable Member
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.

What a silly mistake on my part. Thanks!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.