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 ...
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
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.
also, any idea what keywords I should search for to find a custom visualization?