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...
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.
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.