Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kspotter
New Member

Swiss districts not showing properly

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:

 

kspotter_2-1712908523964.png

 

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_0-1712907894466.png

 

5 REPLIES 5
kspotter
New Member

Indeed, that was the problem.

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

kspotter_0-1712911526716.png

 

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 

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

kspotter_0-1712920741390.png

 

Brunner_BI
Super User
Super User

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
Super User
Super User

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.