Finding values from multiple columns

[PBI123456]

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

[HotChilli · Accepted solution]

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.