cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DanielSon New Member
New Member

How to prevennt Power BI from auto sumnating collumns

Hi all. I have noticed that when I import data from my SQL server Power BI is automatically sumnatiing collumns and ruining my data becuase of it. I was wondering if there was a way to prevent this.Screen Shot 2019-07-11 at 2.03.12 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to prevennt Power BI from auto sumnating collumns

Your data is still in the table normally.  That's just showing the default aggregation is summing.  If you put it into a table, it would sum by default.  But you can click the value and set it to not summarize by default.

PBISum_fieldlist_wrong

 

 

You also have the option to change it at the visual level.  Once you've dragged the value into the Values bucket, click the drop down and select Don't Summarize

View solution in original post

1 REPLY 1
Super User
Super User

Re: How to prevennt Power BI from auto sumnating collumns

Your data is still in the table normally.  That's just showing the default aggregation is summing.  If you put it into a table, it would sum by default.  But you can click the value and set it to not summarize by default.

PBISum_fieldlist_wrong

 

 

You also have the option to change it at the visual level.  Once you've dragged the value into the Values bucket, click the drop down and select Don't Summarize

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,171)