If you ever want to use filled maps with Power BI it is important to use the correct data category and this can be quite confusing for Europe where we have a multitude of different ways of dividing up a country which do not always correspond to the way it is done in the U.S. The data categories for locations that you can use on a filled map are Continent,Country/Region, State or Province and County .
So when I switched the data category for my Belgian provinces to county – the filled map already looked at lot better but not completely since it shows the Grand Duchy of Luxembourg (https://en.wikipedia.org/wiki/Luxembourg) and not the province Luxembourg (https://en.wikipedia.org/wiki/Luxembourg_(Belgium) ) on the map.
So I tried it out for a number of neighboring countries - the next table gives an example of what the different data category labels (in bold in the first row) correspond to for a number of European countries.
I tested it with Belgium, Germany, the Netherlands and France. I did not get it the regions to work correctly for France but this might be because France has officially merged a number of regions since January 1st. France is also subdivided into a number of departments and these were shown on the map as expected.
|Power BI Data Category to use||State or Province||County||Remarks|
|Belgium||Flanders, Walloon region and Brussels Capital region||Antwerp, East-Flanders, Flemish Brabant, Limburg, West-Flanders, Hainaut, Liège, Luxembourg, Namur, Brabant-Walloon||Province Luxembourg not depicted correctly|
|Germany||The different bundesländer: Baden-Württemberg, Bavaria, Berlin, Brandenburg, Bremen, Hamburg, Hesse, Lower Saxony, Mecklenburg-Vorpommern,North Rhine-Westphalia |
Rhineland-Palatinate, Saarland, Saxony, Saxony-Anhalt, Schleswig-Holstein,Thuringia
|France||The different departments as outlined on https://en.wikipedia.org/wiki/List_of_French_departments_by_population .||I removed the overseas departments to make it workable|
|Netherlands||The different provinces: Drenthe, Flevoland, Fryslân, Gelderland, Groningen, Limburg, North Brabant, North Holland, Overijssel, South Holland, Utrecht, Zeeland|
French departments with population density.
Dutch provinces with population density