Forum Discussion
Solved
Joining two matrix visualisation based on the same rows
Hi team! I currently have 2 tables sharing the same rows and I want to see how I can join them together to make the visualisation easier to see. Table 1: Region Employement Type 1 Employemen...
Hi,
PBI file attached.
Hope this helps.
Hi WanqiYao
Create a dimension table with a Region field. Provide relationship from the dimension table to Table 1 and Table 2 based on Region field with 1 to M cardinality. Then write the individual measures for Employment Type 1, Employment Type 2, Technical, and Support with SUM aggregation.