cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MMJen
Helper I
Helper I

Sum of a column

I have a simple table recording Project Managment Information

Each row contains information of a Project Deliverable or resource. 

I have a column which idetnifies which Directorate the deliverable owns the deliverable and one column which holds the total cost of the resoure.

I want to show in a pie or bar chart the total spend per directorate (on an ongoing basis) as this table will continue to be populated during this financial year. 

 

I'm struggling to find the correct formula for this and despite trying various methods I cannot get to see this in what I thought shoudl be straight forward?

 

Can anyone suggest a solution?

1 ACCEPTED SOLUTION

@MMJen

 

Please check your data format and try the solution provided by smoupre, it should be correct.

 

Sum of a column_1.jpg

 

Best Regards,

Herbert

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

Given what you describe, you should be able to drag your cost column to the "Values" of the pie chart and your Directorate column to your "Category" for the pie chart and set your "Value" aggregation to "SUM". 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Hi,

 

Thank you for this.  This does give me a Pie chart per category which is a good start now.  However, it's giving me the Count of the cost not the SUM and i can't see an option under Values or the visualization to give me the SUM here?  Any thoughts?

 

It seems to work on other charts but not this one. 

 

@MMJen

 

Please check your data format and try the solution provided by smoupre, it should be correct.

 

Sum of a column_1.jpg

 

Best Regards,

Herbert

View solution in original post

Thanks all, that's it working, great. 

Another lesson learned..

Sounds like your Value came in as Text. You need to convert it to a numeric value (Decimal or Whole Number) either in the Query Editor or in the data model (middle icon on the left).


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!