Visualisation of the data that doesn't match in a relationship

[Anonymous]

Hi,

I want to display a table of data contain in a table that doesn't match the other table data.

When i only put data of a single table, the data are correctly display but when i put the data of the other table all the data that doesn't "match" ( the one i want to keep ) disappear.

The relation ship between the tablesWhen i only use one table with a data that is not in "salesorders"When i add the field of "salesorders"

Any idea ?

Thanks 

[v-caliao-msft]

@Anonymous,

It's hard to give you the root reason that cause this issue based on your description. You could provide us more detail information.

• what do you mean by "all the data that doesn't match"?
• What's your expected result?

If possible, provide us your PBIX file, so that we can make further analysis.

Regards,

Charlie Liao

[Anonymous]

@v-caliao-msft,

What i mean by "all the data that doesn't match" :

I have one table that containt all the data i want to show, i have another table that only containt the id that match the id of the first table. I want to show all the row where theyre is not match between the two id.

The expected result is a table like this one :

 Thanks,