Forum Discussion

mmtrgt's avatar
mmtrgt
New Member
9 years ago
Solved

Combine data from 2 files into chart

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,

  • 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,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    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,