prevent data summation

[adouds]

I have 20+ columns of data that are always summed when I import into PowerBI and I must select "don't summarize" for each column every time I bring in new data. Is there a way to stop PowerBI from summing all numeric columns. Thank you

[v-sdhruv]

Hi @adouds  ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @adouds  ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @adouds ,

Power BI automatically summarizes the fields when its numeric in nature. If there were few fields, you can manually change it to don't summarize but I can understand it would be a painful task to change for 30+ numeric fields.
The solved link shared by @kushanNa  demonstrates how you can manage for multiple fields and you can try that approach. Another approach would be to -
1.Go to model view--> ctrl+shift or ctrl+click to select the columns

Once you’ve selected the group of columns you want to change find the advanced drop down in the properties window and change the “Summarize by” option to “None”.

Follow this link for more clarity-

How to change summarization for multiple fields

Hope this helps!
If the response has addressed your query, please Accept it as a solution so other members can easily find it.
Thank You!

[kushanNa]

Hi @adouds 

it seems like it is not possible to change the summarize by default 

seems like the workaround is to create an index column and hide it 

https://community.fabric.microsoft.com/t5/Desktop/Table-visual-automatically-summarizing-how-do-i-av...