Swedish municipalities not showing correctly in Filled Maps (Bing)

[MathildaBackman]

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.

[MathildaBackman]

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

[dk_dk · Accepted solution]

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?

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

Data for reference:

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!

[MathildaBackman]

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

[dk_dk]

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:

[MathildaBackman]

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

[dk_dk]

Ö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.

[dk_dk]

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

[MathildaBackman]

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.

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.

[dk_dk]

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....

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

[MathildaBackman]

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.

[dk_dk]

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).