Forum Discussion
Solved
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 ...
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
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:
