cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HarshaBatuka Frequent Visitor
Frequent Visitor

Can someone give me suggestions on creating a shape file for shape map of a country called Nigeria

Can someone give me suggestions on creating a shapefile for shape map of a country called Nigeria including states and districts?

  and steps to import that file to power bi  desktop 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Can someone give me suggestions on creating a shape file for shape map of a country called Niger

Hi @HarshaBatuka,

 

You can download the .shp file for country Nigeria via this site, then you can convert the .shp file to TopoJSON format via this tool. See: https://docs.microsoft.com/en-us/power-bi/desktop-shape-map#use-custom-maps

 

In Power BI desktop, create a table which contains Nigeria states data, set Data Category for the State column as State or Province. Add a shape map into the report, import TopoJSON format file which you get above to the shape map. You can see attached sample file. 

 

q3.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

Re: Can someone give me suggestions on creating a shape file for shape map of a country called Niger

Hi @HarshaBatuka,

 

Please drag .dbf, .prj and .shp files to mapshaper tool then export to TopoJSON file. See detail steps below: 

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Moderator v-qiuyu-msft
Moderator

Re: Can someone give me suggestions on creating a shape file for shape map of a country called Niger

Hi @HarshaBatuka,

 

You can download the .shp file for country Nigeria via this site, then you can convert the .shp file to TopoJSON format via this tool. See: https://docs.microsoft.com/en-us/power-bi/desktop-shape-map#use-custom-maps

 

In Power BI desktop, create a table which contains Nigeria states data, set Data Category for the State column as State or Province. Add a shape map into the report, import TopoJSON format file which you get above to the shape map. You can see attached sample file. 

 

q3.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HarshaBatuka Frequent Visitor
Frequent Visitor

Re: Can someone give me suggestions on creating a shape file for shape map of a country called Niger

Thank You @v-qiuyu-msft

 

 

Highlighted
HarshaBatuka Frequent Visitor
Frequent Visitor

Re: Can someone give me suggestions on creating a shape file for shape map of a country called Niger

@v-qiuyu-msft

 

Hi,

I downloaded Nigeria zip file and tried changing the .shp file to topojson and imported them to power bi desktop.

 

but when I point the cursor on some state it just says state undefined on the custom map 

and when I do it on the sample file you sent me it shows the state name.

 

Am I missing something?

 

Can you give me step wise instructions like what all files do I need to change in the converting tile and what all options to select on the tool before exporting to topo json?

 

tool to convert .shp to topo json.JPG

 

 

Moderator v-qiuyu-msft
Moderator

Re: Can someone give me suggestions on creating a shape file for shape map of a country called Niger

Hi @HarshaBatuka,

 

Please drag .dbf, .prj and .shp files to mapshaper tool then export to TopoJSON file. See detail steps below: 

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.