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! 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.