Connect multiple columns in two tables

Hi sfink22 ,

We can use the unpivot function in Power Query Editor to meet your requirement.

1. We can select [Project Name] and [Owner] in Power Query Editor.

2. Then use the unpivot other columns,

We can get a table like this,

4. And we need to create a relationship between two tables based on Timeline.

5. And we can create a matrix table on report page. Put the [Timeline] to Rows, put the [Attribute] to Columns, put the [value] to values and count it.

We need to configure the [Timeline] is not blank.

6. At last we can create two slicers to control the matrix table.

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.