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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
780 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
776 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
734 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
736 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
777 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
740 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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All