Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |