Forum Discussion
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?
Pikachu-Power , You can create a combine country - city column and try
refer if needed
https://www.biinsight.com/how-to-overcome-map-related-issues-in-power-bi-power-view-and-power-map/
1 Reply
- amitchandakSuper User
Pikachu-Power , You can create a combine country - city column and try
refer if needed
https://www.biinsight.com/how-to-overcome-map-related-issues-in-power-bi-power-view-and-power-map/