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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors