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.
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.
Tag your column with England, Scotland and Wales in it as "State or Province" for your "Data Category" on your Modeling tab.
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.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!