Forum Discussion

sfink22's avatar
sfink22
Helper I
6 years ago

Connect multiple columns in two tables

I have two tables that pull project information. The first table is pulled from our project database and includes all info with deadlines for all of the project steps, the project owner, etc.   The...
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

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.