Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Everybody,
I am working on a function in which team-managers should be able to search people based on their position and certain skills they possess in order to match people to the open position for which they search new people.
I get my data from an Excel sheet and it looks like this:
Employee | Position | Skill 1 | Skill 2 | Skill 3 |
1 | Asset manager | Netwerken | aansturen | Motiveren |
2 | Asset manager | Anticiperen | Samenbindend leiderschap | Verbindend Leiderschap |
3 | Policy director | Analyserend vermogen | Integriteit | Ontwikkelen medewerkers |
4 | Policy director | Motiveren | Netwerken | aansturen |
5 | Asset manager | Motiveren | Netwerken | Integriteit |
I want to create 1 slicer that helps to find the combination of skills that the team-manager wants. So, if I select 'Netwerken', 'Aansturen' & 'Motiveren', I only want to see this combination (underscored for employee 1 and 4) of skills. also it shouldn't matter in what order the skills are handed to me, as examplified in the table above.
Currently, if I make this selection, I get results for all people that possess one of these skills, but not the selectoin of these skills combined, which causes me to find a lot of people that don't have the combination of the skillls I am searching for.
I tried various things with DISTINCT and UNION formulas, but so far I wasn't able to get the correct result.
Do you have some advice for me?
Thanks!
@Wilm117 , One way is unpivoting the table in power bi and use.
https://radacad.com/pivot-and-unpivot-with-power-bi
Another is to create a skill table, join with all three columns. Create three measures, 2 with use relationship to activate inactive joins.
Then add these measures to get final outcome
I tried your second option too, but also this doesn't provide me with my desired outcome. i tried various things and the same 2 things keep happening:
1. i make a selection of multple Skills it shows me all people that possess one of these skills, rather than the combination of these skills for one person
2. The whole page turns blank.
Could there be another way to fix this?
I already tried the unpivoting, but this doesn't create the function that only the combination of selected values pops up. I get the whole list of people that just have one of the selected skills, while I only want to see the people that posess ALL of the skills that i select in the slicer.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
12 |