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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.