How to visualize Europe on MAP

What does your data look like? And what are you trying to end up with? Do you have city and country names availble in one field, such as below?

If so, a Map visual of this data looks like this:

In fact , i mixed in the same list countries and Europe. To give more context, if the development is for Europe i do not want to select all countries saperately. one possibility is to have in the same cell 5 countries ex France, UK, Germany, Italy and Spain and then have 5 spots in EU. if you know how to do one of these 2 options that will be great. thank you

Hi olivier33 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

ToddChitt Thank you for your response.

This is a common scenario when datasets mix individual countries with broader regions like "EUROPE" — especially when you want to visualize everything clearly on a Power BI map.

You can try this workaround:

Power BI’s map visuals work best with specific country names, not general regions like “EUROPE.” Since Power BI doesn’t recognize “EUROPE” as a mappable location, the best approach is to expand that value into the individual countries you want to represent.

For example, if "EUROPE" should represent France, UK, Germany, Italy, and Spain, you can replace each row containing "EUROPE" with 5 rows — one for each of those countries. That way, the map can display each location as a separate point.

 In Power Query:

You can automate this by creating a small list of countries to represent "EUROPE" and expanding them using Power Query. Here's one way to do it:

1. Go to Power Query Editor.
2. Add a custom column with logic like this:

= if [Country] = "EUROPE" then {"France", "UK", "Germany", "Italy", "Spain"} else {[Country]}

1. Then, expand the list in that column to create a new row for each country.
2. Remove or rename the original column if needed.

Now every instance of "EUROPE" becomes multiple rows with real, mappable countries.

Now you'll see the different order counts all in one column, based on the selected sending type.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

Hi olivier33 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy
 

Hi olivier33 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy