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: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
808 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
804 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
762 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
764 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
805 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
768 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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

View All