Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi,
I hope someone can help. I`m trying to put together a dashboard on promotions in my organisation and I`m having some issues with the data model. I have a table of data that shows all the employees promoted in a timeframe (2018), a table of data that shows all employees (snapshot taken monthly) for each month of the year, and a look up table that shows skill type and job family.
The promotion data does not contain job family/ skill type info but the employee table does.
I would like to be able to show how many promotions there were in each job family but i`m struggling to make the link.
Please see the link below to a .pbix file.
Many thanks in advance for any support.
Brendan
Solved! Go to Solution.
@Bfaws , there are 4 pbix. I think I missed the name which one to see.
See if this blog can help: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Hi,
Does anybody have any ideas why this might not be working?
Many thanks for looking.
Brendan
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 50 | |
| 46 | |
| 41 | |
| 39 |