Forum Discussion
joining tables and creating report using Matrix visualization
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 , 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
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?
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
Please share your workbook...thanks
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