RELATIONSHIP

[Anonymous]

Hello everyone,

This is my case.  I have my table with all my managers (40 managers), I want this table to be fix.

Then I have a second production table in where I just have 20 managers (that exist in the first table.

Problem: When I do the relationship, the first table match the second and give 20 filled rows

What I want is to see the others missing 20 managers that did not make production.  I want it looks like the table below.  So, I can know that Mary, Ryan and Louis did no make the production. I truly appreciate your help.   Thank you so much.  

 

[camargos88]

Hi @Anonymous ,

Check this link, it can help you:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

It shows only the correspondent values, if you have any missing you need to select this option to show non-match values.

[lbendlin · Accepted solution]

in your visual, click on the arrow next to one of the fields and click "Show items with no data"