Forum Discussion
joining tables and creating report using Matrix visualization
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.
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
6 Replies
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
