Forum Discussion

hummes's avatar
hummes
Regular Visitor
8 years ago

filtering a skill matrix

I have the follwoing issue and would be happy about some advice.   I am building up a skill matrix for people and would like to have a nice representation of what is the average skill per country p...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi hummes,

 

Your data is not well structured.  It should be a 4 column dataset - Name, Country. Skills and Value.  You should select the first two columns in the Query Editor and then unpivot the others columns.  Then you will be able to use slicers.

 

Hope this helps.

hummes's avatar
hummes
Regular Visitor
8 years ago
Yes you are right. But i get the data like this.
Ist there any Nice way to restructure the data automatical?
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Just Google for "unpivot data in power bi desktop"