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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.