Forum Discussion
Merging Data from Two Columns to Show in Stacked Bar Chart
Hello,
I have created a stacked bar chart to show my team's work capacity. It counts ongoing projects for each person, broken down by phase (Planning, Developing, etc). Up to two people can be assigned to a project...this is represented in the data table by columns "Assignee1" and "Assignee2".
I would like the Axis to show all team member names, and the bar chart to show ALL projects that person is working on, regardless of whether they are listed as "Assignee1" or "Assignee2".
Currently, I have Assignee1 as the Axis, but it only counts projects in which that person is listed as Assignee1 (obviously).
My question: Is there a way I can achieve my goal with a calculated column or relationship table?
I fear I'm suffering from Analysis Paralysis on this one, so thank you in advance for any guidance.
If your dataset is reasonable, you can create 2 copies of your source query. One with only Assignee 1 and their phase and another with only Assignee2 and their phase. Append the two queries together and try to visualize. Let me know if that helps
2 Replies
NipponSahoreResolver II
If your dataset is reasonable, you can create 2 copies of your source query. One with only Assignee 1 and their phase and another with only Assignee2 and their phase. Append the two queries together and try to visualize. Let me know if that helps
This worked perfectly! As a "newbie" to Power BI, I was unfamiliar with the append feature until now. Thank you for pointing me in the right direction!
For anyone reading this, the following links were very helpful in carrying out this solution:
