Hi guys!
I am watching a tutorial and a lady shows how to do a simple bar chart.
On her screen she has just columns.
I do the same and on my laptop I have only SUM option for a column and I cannot get rid of it.
May be I dont understand something. How to get rid of this sum and have just values by default?
Plz help.
2 screenshots are attached.
Hi @Glibberg ,
By default, any aggregated column will return the total value when placed within a visual. To override that, you may adjust the data type from a numeric value to any other value. You can tell that the value with auto-summarize by the icon next to the field:
Alternatively, you can select the field, then "Don't Summarize" under the column tools:
Hope that helps!
Hi @Glibberg ,
By default, any aggregated column will return the total value when placed within a visual. To override that, you may adjust the data type from a numeric value to any other value. You can tell that the value with auto-summarize by the icon next to the field:
Alternatively, you can select the field, then "Don't Summarize" under the column tools:
Hope that helps!
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
