Forum Discussion

moesteez's avatar
moesteez
Icon for Helper I rankHelper I
6 years ago
Solved

Joining two tables without filtering

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 G...
Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    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.

Thim's avatar
Thim
Icon for Resolver V rankResolver V
6 years ago

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