How I can get related column values from a table based on user selection

[sandip]

Hi,

I have 2 tables : Orders and People. 2 tables are related through Region column.

Now in a table I just show Order ID and Category and in another table I have to show realted Country, City and Region Name and also People Name in the second table based on the user will select the Order ID column value.

Table Relationship:

Table 1:

Please suggest how can I achieve this?

[v-xicai · Accepted solution]

Hi @sandip ,

You may change the Cross filter direction of the relationship between the table Orders and People from Single to Both, which will take the two tables treated as a single table.

Then you can put columns Country, City , Region Name and People Name into table visual. So when you filter Orders[Order ID] in visuals, the other linked tables' fields in visuals will return corresponding result.

You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.