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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
amoine
Frequent Visitor

Filled Map : working wirh french departements

Hi,

 

I'm trying to build a filled map using french "département" :

french departements

 

Unfortunately the map show me the "région", which is a group of "département" :

French Régions 

 

As anyone solved this problem ?

 

Thks

 

Alexandre

 

1 ACCEPTED SOLUTION

frdept.PNGAbove is what I see , when I set the Dpt field category as 'County'

county.PNG

 

If you still run into issue, use the Send a Smile/Frown feature in Power BI Desktop and send the pbix file and we can communicate back with the updated pbix file

 

View solution in original post

10 REPLIES 10
DOL51
Frequent Visitor

Just forgot to mention that this field was tagged as COUNTY.

DOL51
Frequent Visitor

I have just solved the issue using a concatenated field starting with the Country 2 letters followed by a comma and the first two digits of the ZIP code. Haute-Marne in France will be "FR"&", "&52 , that is FR, 52. this works OK with me but apparently only for FR

meysun
Resolver IV
Resolver IV

Could you send the pbix file with this issue?. Could you also try to set the data category for the deparment as 'county'  and visualize the map?

amoine
Frequent Visitor

Hi, I tried this, but it's the same issue.

Here is a screen capture with the two types of map representation.

As you can see, on the left one there is only two areas, whereas on the right one there is three dots at the right places.

Capture.PNG

 

Here are the underlying data :

 

Code DptDptNB
33Gironde15
24Dordogne10
16Charente20

 

 

I

 

frdept.PNGAbove is what I see , when I set the Dpt field category as 'County'

county.PNG

 

If you still run into issue, use the Send a Smile/Frown feature in Power BI Desktop and send the pbix file and we can communicate back with the updated pbix file

 

Hi,

 

Perhaps can you test with Data Category = "Postal Code" with an complete code like 33000 ?

I have the same issue with Australian suburbs. The filled map shows a capital city area rather than a suburb. For example there are 850 suburbs in Sydney but all the data is filling is the city of Sydney. I have put in the long and lat for the suburbs and have tried changing the data category to every option possible and also tried changing to using Post Codes rather than suburbs but none of this works. It looks like it has been set up to recognise American geographies and not the rest of the worlds geography hierarchies. Some urgent work really needs to be done on this as this makes the mapping capabilities very limiting. As with the French examples the maps can pick up the suburbs when the Map visual is selected just not with the Filled Map which is what I want. Any assistacne with this would be greatly apreciated.

 

Hi,

Thanks for your post. Any updates/new discoveries on Australian filled maps? I'm looking for LGA'S and SA2's in particular. Cheers.

Hi, thanks for your post. Any new discoveries/updates on getting Australian filled maps? (I'm looking for LGA's and SA2's in particualr). Cheers.

GGR
Regular Visitor

I think you have to set the data category in region even if you want to show the departement.

And your data must be like "Ain, France" for the first french departement.

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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