Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I feel like this should be easy but for the life of me cant seem to work it out.
I have two tables 'Employees' and 'Training'
Emplyees looks like:
EmployeeID | EmployeeName |
1 | Gary |
2 | Ben |
3 | Mary |
Training looks like:
TrainingProgramID | EmployeeID | TrainingProgramName |
9 | 1 | Service |
8 | 3 | Safety |
If I join the tables and create a table with the EmployeeName and TrainingProgramName what I see is:
EmployeeName | TrainingProgramName |
Gary | Service |
Mary | Safety |
But I what I want to see is all the employees, so that:
EmployeeName | TrainingProgramName |
Gary | Service |
Ben | |
Mary | Safety |
Does anyone know how I can get this result without filtering out the employees that dont also exist in the training table?
Thanks
David
Solved! Go to Solution.
Hi @moesteez
Click on the table visualisation and then, on the Visualisations pane, click the down arrow on 'EmployeeName'.
Select the option to 'Show items with no data'.
Your missing rows will then appear.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.
How has Power BI choosen to handle your values?
When i made the table, it sometimes choose the setting "First TrainingProgramName"
When it did this, i got the same result as you.
When i change this from "First" to "Don't Summarize" I got the names of those without any Training Programs.
Hope this will help. 🙂
Hi @moesteez
Click on the table visualisation and then, on the Visualisations pane, click the down arrow on 'EmployeeName'.
Select the option to 'Show items with no data'.
Your missing rows will then appear.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.
this saved me from re-doing my entire 50-table report. thank you.