Combine data from 2 files into chart

[mmtrgt]

Hi,

I'm trying to create a clustered column chart to show data about graduates per industry vs vacancies per industry. The data about graduates per industry i gathered from a national data bank which provides graduates per study. I grouped these studies into industries; automotive, aerospace etc. See pic.

After that I put the vacancies in another file, the numbers I got somewhere else. ( The industries in this file aren't grouped).

Now I want to show the graduates vs vacancies per industry in a clustered column chart. The problem is that I dont know how to make PowerBi recognize that the two industries are the same. 

It either takes ALL the vacancies or ALL the graduates. I would like to know how to just make them appear in the right industries. 

Thanks in advance,

[v-sihou-msft · Accepted solution]

@mmtrgt

In this scenario, you must keep exact same values of "studierichiting (group)" column in both table so that you can build the relationship between two tables on this industry column and mapping data properly.

Regards,