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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

topojson file created with QGIS and converted with mapshaper doesn't validate key with map shape

Hello! 

I'm trying to represent Madrid in its smallest geographical division and when loading the map to power bi it appear empty and greyed, that is something normal, however if I add the key to location it stays greyed and when hoovering in each division it shows as undefined. 

I loaded the excel file of the data of the map that i retriewed from QGIS and also, I have other tables with the same columns so they can be related each other, nevertheless the key map is not recognised, do you know why that can be and how to fix it? 

1 ACCEPTED SOLUTION

Your data looks fine, all attributes are included in the topojson.  What are you trying to display?

 

lbendlin_0-1663967977886.png

 

View solution in original post

13 REPLIES 13
Anonymous
Not applicable

Could be the number of entries?? I have around 4200 entries

nah, that is fine. Works for me with couple 100K entries.  Would you be able to provide a sample topojson file and some sample data?

Anonymous
Not applicable

I'm trying to upload the file but it is not supported, how could I share it to you?

Use your favorite web file service and post the link here.

Anonymous
Not applicable

Your data looks fine, all attributes are included in the topojson.  What are you trying to display?

 

lbendlin_0-1663967977886.png

 

Hey mate! I'm looking a way to make a map just like yours, to represent watersupply networks and polygons (as well as other info). May I know which solution had you addopted, please?

Anonymous
Not applicable

well, that worked for me, thank you, although I'm not able to do it by myself reporducing your steps (that are the usual ones) I thought maybe the map was broken but what is broken is my pc 😄

Anonymous
Not applicable

Hello! thank you for showing me it works, now I'm sure I'm doing something wrong because when I try to reproduce your steps "Count of CUSEC by CUDIS" the map stays grey. Did you do something else apart from loading the data?

No, loaded the data and then replaced the map choice with your JSON.

Anonymous
Not applicable

I would like to use this map as a blueprint to represent many data from Madrid

lbendlin
Super User
Super User

Most likely you stripped away too many attributes in Mapshaper.  Run the export again but preserve the attributes.

Anonymous
Not applicable

I have tried both, but usually I don't touch the atributtes for that reason, in my power bi file I have a table with the key atributte, although the map appears each section when hoovering them shows undefined, I had some issues to represent the map in EPSG: 25830- ETRS89 which it was the default SRC but the map showed shattered, and tried EPSG: 4326- WGS 84 and the map appears perfectly but they key won't work

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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