Training Dashboard

[Noblemission]

Hi, 

I'm trying to create a training dashboard, which shows mandatory training with an organisations. 

I currently have two spreadsheets, one that shows who completed the training (and the date completed) and another with a list of people in the organisation. 

I want one table that shows for those who have done the training a data when it was completed and for those who haven't completed training for them still to show but the data field is blank. 

Thanks

[AndrejZitnay]

Hello @Noblemission 

You need to create relationships to link your uniqe reference.

It seems like people appiers in both of your excels.

https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/2-how-to-manage-data-relationship...

Kind regards.

Andrej

[Noblemission]

Hi, 

Thank you for responding. 

I have a realtionship between the two on staff number but still only show's the people who have completed training not everybody. 

Thanks

Kira

[AndrejZitnay]

Hello @Noblemission 

Can you look into https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Check setting of your Cardinality and Cross Filter Directions.

You might need to find right combination.

I sometimes struggle with that but some setting should fulfil your requirement.

Andrej