cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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.

 

PBI_Stacked_Bar.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

Re: Merging Data from Two Columns to Show in Stacked Bar Chart

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 

View solution in original post

2 REPLIES 2
Highlighted
Resolver II
Resolver II

Re: Merging Data from Two Columns to Show in Stacked Bar Chart

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 

View solution in original post

Highlighted
Frequent Visitor

Re: Merging Data from Two Columns to Show in Stacked Bar Chart

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:

 

Creating new table out of existing one

Append vs. Merge in Power BI and Power Query

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors