Forum Discussion

WanqiYao's avatar
WanqiYao
Frequent Visitor
7 months ago
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...
Need Help
WanqiYao's avatar
WanqiYao
Frequent Visitor
7 months ago

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

  • lbendlin's avatar
    lbendlin
    Super User
    7 months ago

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
    Please show the expected outcome based on the sample data you provided.

    Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • WanqiYao's avatar
      WanqiYao
      Frequent Visitor
      7 months ago

      Hi! Please see the data attached:
      Table 1:

      RegionRole
      OceaniaTechnical
      OceaniaTechnical
      OceaniaTechnical
      OceaniaSupport
      OceaniaTechnical
      AsiaTechnical
      AsiaTechnical

       

       

      Table 2:

      RegionEmpoyment Type
      OceaniaPermanent
      OceaniaPermanent
      OceaniaTemporary
      OceaniaTemporary
      AsiaPermanent
      AsiaPermanent
      AsiaTemporary



      These two are just examples and extract of a bigger table with different size, (table 1 and table 2 have different number of rows and columns in the original format) and thats why I couldn't combine the columns, from this I would like to create a visualisation where the count of each attribute of the same region in one; with the two tables above the visualisation should look like:

      RegionPermanentTemporaryTechnicalSupport
      Oceania2241
      Asia2120


      Once again, thank you so much for the help! and please let me know if this is not clear.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 months ago

    Am still confused.  I do not know what is the input/what is the result expected.