Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone!
I have this data table.
The table shows the skill levels of the people listed in the first column.
The competences are those indicated in the column titles.
Then as values there are the various levels: beginner, confident, expert.
I would like to create one or more visuals in Power Bi Desktop that show me three things:
1- by selecting the person's name in a filter, I want to see the skills they have and at what level.
2- by selecting the skill in a filter, I want to see the name of people who have that skill and at what level.
3- by selecting the skill and the skill level in a filter, I want to see the name of people that have that skill at that level.
Thank you in advance!
Solved! Go to Solution.
@V9_ero , I think you should unpivot all skills columns , then use the table
https://radacad.com/pivot-and-unpivot-with-power-bi
@V9_ero , I think you should unpivot all skills columns , then use the table
https://radacad.com/pivot-and-unpivot-with-power-bi
Thank you! I got what I wanted
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |