Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Sounds like a very simple thing to do in Excel, but i just cant work it out in Power BI.
So my data is something like this - Consider various projects along with the hours spent on different location for that project.
Project No | Location1 | Location2 | Location3 | Location4 |
P0001 | 10 | 12 | 14 | 18 |
P0002 | 40 | 22 | 45 | 93 |
P0003 | 88 | 25 | 33 | 13 |
P0004 | 11 | 87 | 33 | 43 |
I need a new row inserted in the end that gives me a sum of all hours in each location.
Ultimately what i need is a bar chart that shows total hours - a bar for each location.
Im thinking if i can get a row at the bottom that always calculates total for each column, i can transpose it and use it in the bar.
Is there a better way to do this?
thank you
Solved! Go to Solution.
@jatin24 , If I understood correctly your goal, here are the steps:
1. Unpivot location columns in Power Query
Table.UnpivotOtherColumns(#"Previous step", {"Project No"}, "Location", "Value")
2. Create a simple measure:
ValueAmt = SUM('Table'[Value])
3. Use the measure in the matrix / bar chart visual
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
@jatin24 , If I understood correctly your goal, here are the steps:
1. Unpivot location columns in Power Query
Table.UnpivotOtherColumns(#"Previous step", {"Project No"}, "Location", "Value")
2. Create a simple measure:
ValueAmt = SUM('Table'[Value])
3. Use the measure in the matrix / bar chart visual
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Perfect! Thanks so much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
108 | |
88 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |