disable auto summarize

[powerbiexpert22]

how to disable auto summarization of numeric column in power bi?

[DataNinja777]

Hi @powerbiexpert22 ,

What about setting the summarization in Column Tools to "Don't summarize" like shown below?  

Best regards,

[powerbiexpert22]

Hi @DataNinja777 ,

i have to do this setting individually for each and every numeric column in data model which is time consuming process

can it be possible to do it only one time for all numerical fields?

[DataNinja777 · Accepted solution]

Hi @powerbiexpert22 

You probably have seen this too, but the topic was raised below:  

https://community.fabric.microsoft.com/t5/Desktop/Auto-summarizing-of-columns/td-p/3665775

It seems we can select multiple columns from Model View and change in bulk rather than doing it one by one.  

Best regards,

[ppm1]

You can use this script with Tabular Editor.

TabularEditor-Scripts/Basic/Select Columns Remove Auto Aggregations.csx at main · PowerBI-tips/Tabul...

Pat