json realtionship with table (same district name with different pcode)

[mbolognesi]

Dear Power BI gurus,

I am working in a country where some districts have the same name, even though they are in different provinces.

So when I use the json file in shapemap and I select a province, it shows all the districts inside the province, but also a district in another province that has the same name of a district of the selected province. 

The districts are pcoded, so even if they have the same name their pcode is different.

How/where do I change in PowerBi the relationship between the json and my table in order to set it on the pcode attribute instead that on name attribute?

I hope I explained myself....

Thanks!

[v-chuncz-msft]

@mbolognesi,

Check the tutorial below.

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-2-manage-data-relationships/