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

A filled map of the world showing England, Scotland and Wales as separate Regions

I'm trying to create a filled map of all the countries of the world but showing Scotland, Wales and England as separate regions. I can only show them currently as the United Kingdom but the data I have is specific to each individually. Is there a way I can overcome this and show the data properly?

 

Thanks in advance.

7 REPLIES 7
v-haibl-msft
Microsoft
Microsoft

@douglasmarc

 

Filled map can only show the location data with same level. Here you have a column with country data, so the filled map will show Scotland, Wales and England as United Kingdom. To show them as separate regions, you need to put them into a State column, but all the other location data will also be recognized as state.

It is not possible to show country level and state level at the same time.

 

Following two articles introduce us how Filled map works.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-filled-maps-choropleths/

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tips-and-tricks-for-power-bi-map-v...

 

Best Regards,

Herbert

v-haibl-msft
Microsoft
Microsoft

@douglasmarc

 

“Color saturation” should be able to make each region more clear.

 A filled map of the world showing England, Scotland and Wales as separate Regions_1.jpg

 

Best Regards,

Herbert

If you change your Data from England to England,United Kingdom. This should fix the issue

All the best,

Sean

Greg_Deckler
Super User
Super User

Tag your column with England, Scotland and Wales in it as "State or Province" for your "Data Category" on your Modeling tab.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Thanks for the help, it's working but only for states now, the other countries globally have been removed. Georgia the country is now showing up as Georgia the state. Australia is showing up as Western Australia.

 

I've tried creating a separate column with just region (only including England Scotland and Wales) and adding it to the location data (have two entries, one for country and another for state) but it'll only show one or the other and not both.

@douglasmarc

 

You can try with Drill function as below. Not sure if it can meet your requirement.

Data Category of Countries column is “Country/Region”.

Data Category of Regions column is “State or Province”.

A filled map of the world showing England, Scotland and Wales as separate Regions_2.jpg

 

Best Regards,

Herbert

Thanks for that. It doesn't really help as I need it to show on the main map without drilling down. Thanks though.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors