Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
4 years ago
Solved

Map does not show Saxony

Hi all,

 

i dont know why but the map show all states for Germany but not Saxony. I use following column to rename the german states to the english one so that Power Bi can recognize the states:

 

federalstate = SWITCH(Table_States[State],

"Baden-Württemberg", "Baden-Württemberg",

"Bayern", "Bavaria",

"Berlin", "Berlin",

"Brandenburg", "Brandenburg",

"Bremen", "Bremen",

"Hamburg", "Hamburg",

"Hessen", "Hesse",

"Niedersachsen", "Lower Saxony",

"Mecklenburg-Vorpommern", "Mecklenburg-Western Pomerania",

"Nordrhein-Westfalen", "North Rhine-Westphalia",

"Rheinland-Pfalz", "Rhineland-Palatinate",

"Saarland", "Saarland",

"Sachsen", "Saxony",

"Sachsen-Anhalt", "Saxony-Anhalt",

"Schleswig-Holstein", "Schleswig-Holstein",

"Thüringen", "Thuringia",

"federalstate unknown")

 

There is no typing error for Saxony as far as i see and i see the right mapping in the table. 

 

When I use a direkt column with Saxony the map recognize Saxony but not with the switch-column. 

 

Someone has an idea where the problem is?