Forum Discussion
Auto summarizing of columns
Hello
When I load any data into Power BI it always set the summarize function on numeric fields, so I get the Sigma signs next to them. I always remove these, setting them to "Don't summarize" as I prefer to use DAX for this. So I have to go through all my columns turning off the summarize function. Is there a way to stop Power BI doing this in the first place?
Thanks.
AFAIK, there's no global settings to change Summarize by function for numeric data types. However, you can turn off auto detect data types in Global options under Data Load. other option is to go into Model View and select multiple columns then change the Summarize by option to None under Advance section.
Hope this helps.
3 Replies
- Idrissshatila
Super User
Hello JamesNewcombe ,
it automatically add the summarized icon to all numeric types, it doesn't effect you writing dax nor effects the data.
it's just when you drag the column field into a visual, then it automatically aggregates it, but in the case where you create your dax then this won't affect you.
- amustafa
Solution Sage
AFAIK, there's no global settings to change Summarize by function for numeric data types. However, you can turn off auto detect data types in Global options under Data Load. other option is to go into Model View and select multiple columns then change the Summarize by option to None under Advance section.
Hope this helps.
2026 answer.
With new power bi project file format. (If you save your pbix file to pibp)
Your power bi file now is distributed into parts.
Go to folder: ?your_power_bi_file_name?.SemanticModel/defintion/tables, and you will find all the tmdl files. These are your table definitions. Open a file and you will able to find each column and their `summarizeBy`
`summarizeBy = .....(count, sum, ect...)` this is the attribute that you want to update.
The trick here is how to change them all at once. I am able to do this via Search and replace all with help of regular expression on in vs code.
Just open the folder in vs code, and find and replace this from`summarizeBy = count` --> `summarizeBy = none`
In Search with regex* (make sure highlighted/on where red arrow is pointing at)
find them all using --> summarizeBy:\s*(Sum|Average|Count|Min|Max|DistinctCount)
replace with string --> summarizeBy : none
** You might need to re-open your powerbi file to take effect. **
Bonus: why not as your AI to replace it all for you.
