Auto summarizing of columns

[JamesNewcombe]

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.

[amustafa · Accepted solution]

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.

[Idrissshatila]

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.