Forum Discussion
WanqiYao
7 months agoFrequent Visitor
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...
- 7 months ago
Hi,
PBI file attached.
Hope this helps.
WanqiYao
7 months agoFrequent Visitor
Hi krishnakanth240 Ashish_Mathur lbendlin , thank you so much for the replies! And apologies I wasn't clearer before. The original tables are in the format of:
Region Employment
Oceania Eployment Type 1
Oceania Eployment Type 1
Oceania Eployment Type 2
The table mentioned above is already using a count measure for the visualisation, likewise with the second table, so it would be a many to many relationship unfortunately, and joining the table wouldn't solve the issue.
lbendlin Could you kindly elaborate on how to achieve it? I'm not sure what you mean.
Again, thank you so much for the replies.
Regards,
Wanqi
Ashish_Mathur
7 months agoSuper User
Am still confused. I do not know what is the input/what is the result expected.