Display data that is linked to no data

[Charline_74]

Hello, 

I have two tables : 

And I would like to display the ID of the UVs that are not linked to a US ID. 

But I can't manage to put a visual in place with this information ? 

Thanks, 

Cha

[rubayatyasmin · Accepted solution]

Hi, @Charline_74 

If you want to display the IDs of UVs that are not linked to a US ID, you can do this by creating a new table of unlinked UVs and then displaying this table in a visual.

Here's a step-by-step guide:

1. Load your data and establish the one-to-many relationship between the "UV monitoring" and "User Story" tables. This should be straightforward if the two tables share a common ID. In the "Relationships" tab, drag and drop the connecting field from the "UV monitoring" table onto the "User Story" table to create this relationship.

2. In Power Query Editor, create a new table of UVs that aren't linked to a US ID. This can be done by merging the two tables on the shared ID and then filtering for null values in the "User Story" table's ID column.