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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply

Swedish municipalities not showing correctly in Filled Maps (Bing)

I have a Power BI report showing all the 290 swedish municipalities in a Filled Map (Bing).
I have used the names for the municipalities in the field for Location and for 284 of the municipalities it works just fine.

For example:
Örebro kommun is showing up like a filled area in the map.
Vingåkers kommun is showing up just as fine.

But these municipalities are not showing up as municipalities. In some cases the show up as Cities. Not usefull for this report.


Jönköpings län: Gislaveds kommun, Gnosjö kommun, Jönköpings kommun

Uppsalas län: Tierps kommun, Älvkarleby kommun, 

Västra Götalands län: Mölndals kommun


I have tried to rename them in all the ways I use to fix this issue with other municipalities that Bing has problems finding.
One of them is to write in english, another way is to add the county to the name, but for these 6 I can't make it work.

Does anyone have a solution?
And yes - I need to use Filled Maps. And I don't want the cities. And no, Lat or Long isn't applicable.

Och ja, du kan svara på svenska om du vill/kan.

1 ACCEPTED SOLUTION
dk_dk
Super User
Super User

Hej @MathildaBackman 

 

I do not have a solution, but I did a test copying out some of the names you have issues with and it seems to work fine for me?

dk_dk_0-1729845081858.png

The map seems to show the kommun area, not the cities.

 

Data for reference:

dk_dk_1-1729845105632.png

And I just added this to the Location of the Filled Map visual.

 

 

Could you:

 

- check the spelling of the values and make sure they are correct, and there aren't any trailing whitespace characters

- try a separate data source with the kommun names

- try to filter down your data to specific columns at a time and see if the visual updates correctly?

- set the data category of your column to "County" (see this link, under the Power BI section: https://www.drakeanalytics.se/svenska-kommuner-i-qlik-tableau-power-bi/)

 

Sorry I do not have any more tips, I hope you are able to resolve it!

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

11 REPLIES 11

OMG! Great. But how?
Show me the names of them that you are using. 

dk_dk
Super User
Super User

Hej @MathildaBackman 

 

I do not have a solution, but I did a test copying out some of the names you have issues with and it seems to work fine for me?

dk_dk_0-1729845081858.png

The map seems to show the kommun area, not the cities.

 

Data for reference:

dk_dk_1-1729845105632.png

And I just added this to the Location of the Filled Map visual.

 

 

Could you:

 

- check the spelling of the values and make sure they are correct, and there aren't any trailing whitespace characters

- try a separate data source with the kommun names

- try to filter down your data to specific columns at a time and see if the visual updates correctly?

- set the data category of your column to "County" (see this link, under the Power BI section: https://www.drakeanalytics.se/svenska-kommuner-i-qlik-tableau-power-bi/)

 

Sorry I do not have any more tips, I hope you are able to resolve it!

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





The municipalities you have visable in your map, are the ones that works just fine.
These are the ones not showing up:

Jönköpings län: Gislaveds kommun, Gnosjö kommun, Jönköpings kommun

Uppsalas län: Tierps kommun, Älvkarleby kommun, 

Västra Götalands län: Mölndals kommun

I have Gnosjö and Mölndal on my map as well.

I added Gislaved and Tierps just to test and they show up as well:

dk_dk_0-1729846629292.png

 

dk_dk_1-1729846639089.png

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





OMG! Great. But how?
Show me the names of them that you are using. 

Since these didn't work:

Jönköpings län: Gislaveds kommun, Gnosjö kommun, Jönköpings kommun

Uppsalas län: Tierps kommun, Älvkarleby kommun, 

Västra Götalands län: Mölndals kommun

 

 

 

Örebro kommun 34
Vingåkers kommun 53
Mölndals kommun 18
Gnosjö kommun 34
Tierps kommun 33
Gislaveds kommun 33

 

This is my data, I am not even using the num values for anything. I just copied them from your post. Which is why I suspect that maybe in your data source there are some invisible characters causing some issue, or maybe the data category is not set correctly, and for some reason it prioritizes showing stuff as cities instead of counties / kommuns.

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





You could try to paste this into power bi as a new datasource and see if the visual will display correctly with it.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





My file is no good for usage, since I have made multiple attemps to make this issue go away.
But of course - here they are.

This Table is used as a bridge from the actual source to Location for Power BI and Filled Maps.

The relationship is set to the column Kommun - and the field I'm using for the Location field in Power BI Filled Maps is the last one.

MathildaBackman_0-1729848020725.png

 

So I need the perfect value in the last column, and by perfect I meen the value that works for showing up in Filled Maps as a municipality.


When I use the Power BI Location from your example, for instance for Jönköping Municipality, that value highlights only the city. When I use "Jönköpings kommun" it highlights the county.

I spent a bit of time trying to find a good source for the kommuns, but it seems there is always some issue.

The closest I could get to was this list from Wikipedia:
https://sv.wikipedia.org/wiki/Lista_%C3%B6ver_Sveriges_kommuner

 

If you load this in, and change the column data category to County, it will show all the kommuns, except for two:

 

Orusts kommun needs to be renamed to Orust kommun

 

And then it confuses Habo kommun and Håbo kommun, and I could not get that fixed no matter what....

 

dk_dk_0-1729856809075.png

 

so it shows double for Habo and nothing for Håbo...

Sorry I can't be of more help.


I met @aarvidsson at the Fabric conference in Vegas earlier this year, where we briefly talked about the topic of the Swedish alphabet, particularly the special letters, causing issues. Alex, would you have any idea how to resolve this?

Best,

Daniel

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





But County is not the same as Municipality....
For example the municipality of Gislaved is in the County of Jönköping.
But I will look into that soruce, and see if I can get it to help me with them 6 municipalities that keeps on bugging out.

So hard to get stucked like this.

My understanding, based on this blog post from earlier https://www.drakeanalytics.se/svenska-kommuner-i-qlik-tableau-power-bi/

is that the category "county" would correspond to kommun. But reading through the blog post they also had some issues with Habo/Håbo, and some other kommuns as well. it seems that adding a country level to the location hierarchy solves that, so maybe you could try that as well? (add a Country column with the constant value "Sweden" for all the rows, and then bring the Country and Kommun columns to the Location well of the map visual).




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.