cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbolognesi Frequent Visitor
Frequent Visitor

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

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!

1 REPLY 1
Community Support Team
Community Support Team

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

@mbolognesi,

 

Check the tutorial below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.