Issues with Data Model

[Bfaws]

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.

Click here for file 

Many thanks in advance for any support.

Brendan

[Anonymous · Accepted solution]

Hi  @Bfaws ,

Change the direction of the relationship between "Employee Lookup" and "Resource report" from single to both.

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@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...

[Bfaws]

@amitchandak 

Apologies. Only one file now.

Thanks

Brendan

[Bfaws]

Hi,

@amitchandak 

Does anybody have any ideas why this might not be working?

Many thanks for looking.

Brendan