Forum Discussion
Solved
Finding values from multiple columns
Hi,
I have a table that has 4 columns. I need help creating an visual that shows which person from columns 2,3,and 4 is involved in the project column.
1. Project
2. Person 1
3. Person 2
4. Person 3
Example - visual needs to show that jacob is involved with projects a and b
Unpivot the 3 'Person' columns in Power Query.
In powerbi, drag project and person on to a table.
Decide whether you want to focus on Projects or Person. Whatever you decide, make a slicer from that field.
1 Reply
Unpivot the 3 'Person' columns in Power Query.
In powerbi, drag project and person on to a table.
Decide whether you want to focus on Projects or Person. Whatever you decide, make a slicer from that field.