Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
h_l
Post Patron
Post Patron

Country mapping when mark column as "Country"

Hi there,

 

If a column is set to type: country, will Power BI automatically detect different value type and knows they are same?

E.g. a country table contains column:

usa

can

jpn

kor

ind

 

then, if another table contains a column value:

America

Canada

Japan

Korea

Indea

 

Possible to create active relationship and Power BI auto detect & map them?

Thank you.

H

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @h_l 

Those values are not the same so there'd be no relationship.  You'd need to create another column in both tables and in that assign a unique number to each country.  That way you can establish a relationship.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @h_l 

Those values are not the same so there'd be no relationship.  You'd need to create another column in both tables and in that assign a unique number to each country.  That way you can establish a relationship.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


I see, so the type of "Country" will help to "MAP" visual, but not Power BI's detect....

Thanks.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.