Swiss districts not showing properly

[kspotter]

Hello,

My problem is quite simple.

I can display swiss canton using the map card. However I cannot display the districts of a given canton.

Let's see per example Valais:

Thanks a lot for your help

Here are the data:
Canton,Two-letter Abbr.,Numeric,FIPS 10-4,NUTS-3,District
Aargau,AG,19,SZ01,CH033,
Appenzell Innerrhoden,AI,15,SZ10,CH054,
Appenzell Ausserrhoden,AR,16,SZ02,CH053,
Berne,BE,2,SZ05,CH021,
Basel-Landschaft,BL,13,SZ03,CH032,
Basel-Stadt,BS,12,SZ04,CH031,
Fribourg,FR,10,SZ06,CH022,
Geneva,GE,25,SZ07,CH013,
Glarus,GL,8,SZ08,CH051,
Grisons,GR,18,SZ09,CH056,
Jura,JU,26,SZ26,CH025,
Lucerne,LU,3,SZ11,CH061,
Neuchâtel,NE,24,SZ12,CH024,
Nidwalden,NW,7,SZ13,CH065,
Obwalden,OW,6,SZ14,CH064,
St. Gallen,SG,17,SZ15,CH055,
Schaffhausen,SH,14,SZ16,CH052,
Solothurn,SO,11,SZ18,CH023,
Schwyz,SZ,5,SZ17,CH063,
Thurgau,TG,20,SZ19,CH057,
Ticino,TI,21,SZ20,CH070,
Uri,UR,4,SZ21,CH062,
Vaud,VD,22,SZ23,CH011,
Zug,ZG,9,SZ24,CH066,
Zürich,ZH,1,SZ25,CH040,
Valais,VS,23,SZ22,CH012,Brig
Valais,VS,23,SZ22,CH012,Conthey
Valais,VS,23,SZ22,CH012,Entremont
Valais,VS,23,SZ22,CH012,Goms
Valais,VS,23,SZ22,CH012,Hérens
Valais,VS,23,SZ22,CH012,Leuk
Valais,VS,23,SZ22,CH012,Martigny
Valais,VS,23,SZ22,CH012,Monthey
Valais,VS,23,SZ22,CH012,Saint-Maurice
Valais,VS,23,SZ22,CH012,Sierre
Valais,VS,23,SZ22,CH012,Sion
Valais,VS,23,SZ22,CH012,Visp

[kspotter]

Indeed, that was the problem.

Any idea how I should format the districts in order to show all of them properly ?

[Brunner_BI]

That depends on a couple of factors.

try searching some in Bing with different names (English, French etc) and see if bing gets it right

then use that in Power BI but do data category district 

[kspotter]

I couldn't get it to work for specific district such as Monthey and Martigny, even though bing told me it's the right district name. mmmh

[Brunner_BI]

Try using the drilldown in your visual to make sure you drill from Canton -> District

then the search algorithm will try to find the district inside that canton only and not like worldwide or so

[Brunner_BI]

Try using the drilldown in your visual to make sure you drill from Canton -> District

then the search algorithm will try to find the district inside that canton only and not like worldwide or so