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...
hummes's avatar
hummes
Regular Visitor
8 years ago

Thanks for your help.. I manged to draw a quite nice and comprehensive spider chart.

 

I have countries as the "pillars" of the web and have the average and max skill values as "y-axxis" values.

 

I now want to add a slicer to make this less complex to view. But l ran into the following problems

 

1. I want to select "Skill 1" in a list and the average and max value should be displayed in the chart. So 1 entry in the slicer controlling 2 dataset on the chart -> is this possible?

 

2. I have no data field to use as a "skill list" to select from. How can I create such a list for a slicer.

I tried to add a column "Skills" with all the skills as rows. But this is not linked to my data. How to manage this?

Ashish_Mathur's avatar
Ashish_Mathur
Super 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
      Super User
      8 years ago

      Hi,

       

      Just Google for "unpivot data in power bi desktop"