Forum Discussion

frippex's avatar
frippex
New Member
3 years ago

Relations between two tables

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!

Need Help

1 Reply

  • HarishKM's avatar
    HarishKM
    Super User
    3 years ago

    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