Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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 ...

v-deddai1-msft
6 years ago
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

Community Support

6 years ago

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

Not applicable

6 years ago

Please share your workbook...thanks

v-deddai1-msft
Community Support
6 years ago
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

Related content