Training Dashboard

Question

Hi,&nbsp;&nbsp;I'm trying to create a training dashboard, which shows mandatory training with an organisations.&nbsp;&nbsp;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.&nbsp;&nbsp;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.&nbsp;&nbsp;Thanks

andrejzitnay · Answer

Hello&nbsp;Noblemission&nbsp;&nbsp;You need to create relationships to link your uniqe reference.It seems like people appiers in both of your excels.&nbsp;https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/2-how-to-manage-data-relationships&nbsp;Kind regards.&nbsp;Andrej

noblemission · Answer

Hi,&nbsp;&nbsp;Thank you for responding.&nbsp;&nbsp;I have a realtionship between the two on staff number but still only show's the people who have completed training not everybody.&nbsp;&nbsp;Thanks&nbsp;Kira

andrejzitnay · Answer

Hello&nbsp;Noblemission&nbsp;&nbsp;Can you look into&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationshipsCheck setting of your Cardinality and Cross Filter Directions.You might need to find right combination.&nbsp;I sometimes struggle with that but some setting should fulfil your requirement.&nbsp;Andrej&nbsp;

Forum Discussion

Training Dashboard

3 Replies

Related content

Power BI Training

Defender Training Campaigns - Marrying the Training Campaign to the User Training

Power BI Training - Best Site

Fabric account for training

DAX Training