Forum Discussion
Joining two matrix visualisation based on the same rows
Hi,
PBI file attached.
Hope this helps.
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
Hi! Please see the data attached:
Table 1:
| Region | Role |
| Oceania | Technical |
| Oceania | Technical |
| Oceania | Technical |
| Oceania | Support |
| Oceania | Technical |
| Asia | Technical |
| Asia | Technical |
Table 2:
| Region | Empoyment Type |
| Oceania | Permanent |
| Oceania | Permanent |
| Oceania | Temporary |
| Oceania | Temporary |
| Asia | Permanent |
| Asia | Permanent |
| Asia | Temporary |
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:
| Region | Permanent | Temporary | Technical | Support |
| Oceania | 2 | 2 | 4 | 1 |
| Asia | 2 | 1 | 2 | 0 |
Once again, thank you so much for the help! and please let me know if this is not clear.
Hi,
PBI file attached.
Hope this helps.