Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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.
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.
However, if the data type in the same bar chart visualisation is numeric, the aggregation method will differ.
In a table visualisation, you also have the option to choose not to aggregate.
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.
There are 15 records in the table and i'm getting this
so to me it is summing the number of records in the column
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.
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.
However, if the data type in the same bar chart visualisation is numeric, the aggregation method will differ.
In a table visualisation, you also have the option to choose not to aggregate.
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.
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |