Forum Discussion

adouds's avatar
adouds
New Member
1 year ago
Solved

prevent data summation

I have 20+ columns of data that are always summed when I import into PowerBI and I must select "don't summarize" for each column every time I bring in new data. Is there a way to stop PowerBI from su...
  • v-sdhruv's avatar
    1 year ago

    Hi adouds ,

    Power BI automatically summarizes the fields when its numeric in nature. If there were few fields, you can manually change it to don't summarize but I can understand it would be a painful task to change for 30+ numeric fields.
    The solved link shared by kushanNa  demonstrates how you can manage for multiple fields and you can try that approach. Another approach would be to -
    1.Go to model view--> ctrl+shift or ctrl+click to select the columns

    Once you’ve selected the group of columns you want to change find the advanced drop down in the properties window and change the “Summarize by” option to “None”.

    Follow this link for more clarity-

    How to change summarization for multiple fields

    Hope this helps!
    If the response has addressed your query, please Accept it as a solution so other members can easily find it.
    Thank You!

  • v-sdhruv's avatar
    1 year ago

    Hi @adouds  ,
    Just wanted to check if you had the opportunity to review the suggestion provided?
    If the response has addressed your query, please accept it as a solution  so other members can easily find it.
    Thank You