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?
Solved! Go to Solution.
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".
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.
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).
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps