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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lhs
New Member

Imported SQL Server table's columns are being automatically summed - i don't want that

Hi,

I imported data from a sql server table.  But somehow the integer columns are being automatically summed.  Is this summing of integer columns on by default?  How do I turn it off?

Thanks,

Lloyd

 

lhs_0-1729010563694.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for the reply from az38 , please allow me to provide another insight:

Hi, @lhs 

As az38  mentioned, the aggregation in your requirements is simply a standard feature of Power BI. I understand your confusion, but you may soon find that this is a very useful capability.

 

When applying columns to visualisations, you only need to right-click on the corresponding column to select the aggregation method.

vlinyulumsft_0-1729045315028.png

It's important to note that the available aggregation methods can vary depending on the data type and the type of visualisation.
For instance, in a bar chart, if your data type is text, the default aggregation method will be the count you’ve observed.

vlinyulumsft_1-1729045315029.png

 However, if the data type in the same bar chart visualisation is numeric, the aggregation method will differ.

vlinyulumsft_2-1729045358623.png

In a table visualisation, you also have the option to choose not to aggregate.

vlinyulumsft_3-1729045358626.png

For further details, please refer to:

Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn

Regarding how to modify data types, please refer to:

Data types in Power BI Desktop - Power BI | Microsoft Learn

 

I hope my explanation is clear enough for you to understand.

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
az38
Community Champion
Community Champion

hi @lhs 

this sum  symbol does not mean the values are summed. It just highlights numeric columns. just interface feature


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

There are 15 records in the table and i'm getting this 

lhs_0-1729013056938.png

 

so to me it is summing the number of records in the column

Anonymous
Not applicable

Thanks for the reply from az38 , please allow me to provide another insight:

Hi, @lhs 

As az38  mentioned, the aggregation in your requirements is simply a standard feature of Power BI. I understand your confusion, but you may soon find that this is a very useful capability.

 

When applying columns to visualisations, you only need to right-click on the corresponding column to select the aggregation method.

vlinyulumsft_0-1729045315028.png

It's important to note that the available aggregation methods can vary depending on the data type and the type of visualisation.
For instance, in a bar chart, if your data type is text, the default aggregation method will be the count you’ve observed.

vlinyulumsft_1-1729045315029.png

 However, if the data type in the same bar chart visualisation is numeric, the aggregation method will differ.

vlinyulumsft_2-1729045358623.png

In a table visualisation, you also have the option to choose not to aggregate.

vlinyulumsft_3-1729045358626.png

For further details, please refer to:

Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn

Regarding how to modify data types, please refer to:

Data types in Power BI Desktop - Power BI | Microsoft Learn

 

I hope my explanation is clear enough for you to understand.

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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