Forum Discussion
Solved
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 ...
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
Super User
Super UserHello 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.