joining tables and creating report using Matrix visualization

[Anonymous]

I have two tables as below

table1

PK1	PK2	name	states	age
a	b	AM	arizona	5
a	b	AM	cali	5
a	b	AM	ny	5
a	b	AM	nj	5
a	b	AM	wy	5

table2

PK1	salary
a	201

I need to join those two tables on PK1 and create output as below

Currently i have started using matrix visualization and was able to get the below table. I couldnt get the 'states' column in the second last position as then it populates the column 'age' on all rows.

Is there any way i could achieve the result that I want and then join to table2 above to get the salary column?? Do i need to change the structure of my table1? it is manually created. While the second table is a calculation.

[amitchandak]

@Anonymous , You can join on PK1 one column. But you can not get the format in the first image. Check if there is some custom visual

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[Anonymous]

Do you think that the below view is possible? I am not sure how to perform the join as in the first table PK1 occurs multiple times but in the second table PK1 would be there only for 1 time. I dont want to repeat the salary multiple times.

[v-deddai1-msft]

Hi @Anonymous ,

Is the screenshot below you want?

Just close the stepped layout and icon of row header and put states in the last filed of row:

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

Best Regards,

Dedmon Dai

[Anonymous]

Please share your workbook...thanks

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

This is the forum of power bi, so I realized it in power bi. Please refer to pbix file：https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Eb0R0V6MLqRCpjQCRrKqLuYBvgsGsPTE7uE5zc0ocYSCog?e=Mz3pNc

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

Best Regards,

Dedmon Dai

[Anonymous]

also, any idea what keywords I should search for to find a custom visualization?