Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Hello @Noblemission
You need to create relationships to link your uniqe reference.
It seems like people appiers in both of your excels.
Kind regards.
Andrej
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |