Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Dbstedman
New Member

Data not Summarizing

‎04-04-2022 07:32 AM

I'm looking for a way to sum the values into just East and West so I don't have four lines for each. I'm new to Power BI so it could just be an issue with how I imported my data. Is there something easy in the settings I missed or do I need to adjust my data import? Thank you

 

E-W Summary.png

Labels:
Message 1 of 5
789 Views
0
1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

‎04-04-2022 07:36 AM

Hi @Dbstedman ,

 

Whenever you move certain columns to Power BI table visual, if they are of numeric type they should summarise themselves by default to SUM.

What are the data-types of all the columns in your screenshot above?

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog | YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

Message 2 of 5
785 Views
4 REPLIES 4
ribisht17
Community Champion
Community Champion

‎04-04-2022 07:59 AM

Check this one, 

ribisht17_1-1649084415346.png

 

 

Regards,

Ritesh

 

Message 5 of 5
743 Views
0
Dbstedman
New Member

‎04-04-2022 07:54 AM

I found my mistake. The number coloumns were set to "Don't Summarize". Thanks for the help!

Message 4 of 5
745 Views
Pragati11
Super User
Super User

‎04-04-2022 07:36 AM

Hi @Dbstedman ,

 

Whenever you move certain columns to Power BI table visual, if they are of numeric type they should summarise themselves by default to SUM.

What are the data-types of all the columns in your screenshot above?

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog | YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Message 2 of 5
786 Views
Dbstedman
New Member
In response to Pragati11

‎04-04-2022 07:52 AM

The first column should be text and the next three are whole numbers.

Message 3 of 5
749 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

View All