How to design matrix for data source with one-to-many relations

[msuser48]

I have joined two tables (differentiated by green and blue column color) on the [Test_Id] column in a SQL Server view, such that we have the following table:

"Green" table: Image and image_name are connected to "Test_ID". The same imagfe/image_name cannot exist under more than one test_id. Image_name is the table's unique key.

"Blue" table: Test_ID can have several different nx_id and yx_ids. nx_id and yx_id combined is the table's unique key.

Question: How do I visualize this table in a nice way in PowerBi / how would an expert go about this? How should the rows, values, columns be arranged? I tried a table and a matrix, but I haven't found a nice way. Especially since images (formatted using URL-address) can only be chosen in the "Values" list.

[v-kkf-msft]

Hi @msuser48 ,

Which fields do you want to add to the matrix? Does having the image URL as the value of the matrix not match your desired output?

Best Regards,
Winniz