Power BI Desktop (September 2021) Automatic Data Summation

[jhgorham]

Hi all, I was wondering if anyone found an easy way to turn off automatic summation when loading data into Power BI Desktop. I find that all of my numeric columns are automatically summed and I have to manually go in and select "Don't summarize" for every single spreadsheet I load in. I have seen others try to solve this problem, but their solutions are either outdated or do not apply to PBI Desktop. I am really tired of having to turn off summation for every individual column I use. 

[Ritaf1983 · Accepted solution]

Hi @jhgorham 

Don't think that any solution exists.
You can suggest it as the idea here :

https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=switch%20off%20automatical%20summirization%...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly