Relations between two tables

[frippex]

Hi guys,

For the ease of it I will try to explain my scenario using Countries and Offices:

- excel_countries.xlsx with a table called "Countries" (1 row per country)

- excel_offices.xlsx with a table called "Offices" (table headers are Countries, Cities. A country can have 0 Cities with Offices or several Cities with Offices so there can be empty to many rows per Country)

In PowerBi I have created a table to the left which is displaying all Countries (1 per row).

On the right side I would like to display the Offices in that country that has been selected on the table to the left.

How can I acchieve this?

1) Can this be done?

2) Can this be done in the service/app version or do I need to have the Desktopversion to get this going?

Thanks!

[HarishKM]

@frippex Hello,
You can load both table and then create a relationship ( one to many relationship) in your power bi desktop software. 

Then your expected output will be like this.

Thanks

Harish M