Forum Discussion

Charline_74's avatar
Charline_74
Icon for Resolver I rankResolver I
3 years ago
Solved

Display data that is linked to no data

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

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    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.

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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.