March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi Team ,
I have China , Thailand , Hongkong , Malaysia , I wanna use shape map to visualize these countries into the shape map.
how to successfully use such map ? i have no idea while i tried to research multiple documents but no output and a bit hectic with the different ways to acheive it.
Anyone can tell me how to settle this ?
Thanks with Regards,
Chanleakna Hang
Solved! Go to Solution.
You need to do a few things. Firstly, have a column in your data which holds the Country information you have mentioned. Select that field in your field picker and use the Model Tab of your menu ribbon and give that field a 'Data Category' of Country. Put this into the location area of the visual setup.
Next you need a field that is going to act as the highlighter for your shape map, usually this will be a value field such as "Revenue" or something. Place this field into the "Colour saturation" area of the visual setup.
Lastly, in your visual set up there is an icon that looks like a paint roller, select this and you will have a grouping called 'Data colors'. This will let you choose what your data saturation gradient is, i.e. red to green.
Many many ways to set this visual up, but the above is a common method that should hopefully get you started.
Hi,
I have converted shp files into json files in order to do mapping in power bi, however the trouble I face is there are no data attributes with these shape files when putting them into map shaper. I have dbf files, so question iss what to do next, do I need QGIS?
You need to do a few things. Firstly, have a column in your data which holds the Country information you have mentioned. Select that field in your field picker and use the Model Tab of your menu ribbon and give that field a 'Data Category' of Country. Put this into the location area of the visual setup.
Next you need a field that is going to act as the highlighter for your shape map, usually this will be a value field such as "Revenue" or something. Place this field into the "Colour saturation" area of the visual setup.
Lastly, in your visual set up there is an icon that looks like a paint roller, select this and you will have a grouping called 'Data colors'. This will let you choose what your data saturation gradient is, i.e. red to green.
Many many ways to set this visual up, but the above is a common method that should hopefully get you started.
Hi @Anonymous I want to use my Floor Plan data to show heatmap like the attached image. Is this possible using Shapemap visual. Any help on this is really appriciated. Thanks
Example Resutl I am looking for is:
@Anonymous Hi , Thanks , i do as per your advise and it's work . But a bit slow which i have so many country on the map 😞
Anw, really appreciated your support 🙂
Hi @Chanleakna123,
You can use custom maps with Shape Map as long as they are in the TopoJSON format. If your map is in another format, you can use online tools such as Map Shaper to convert your shapefiles or your GeoJSON maps into the TopoJSON format.
Take the China for example, you can get a China .shp file here, then you can convert the .shp file to TopoJSON via the Map Shaper tool as mentioned above. Add this custom map to Power BI desktop and visualize data via ShapeMap visual. You can see atatched file.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-shape-map
Best Regards,
Qiuyun Yu
Thank you so much. I have been researching this for days and you are the only person in the whole web who gave an easy and correct solution!!!!!
@v-qiuyu-msft Hi Dear,
I'm in cambodia and i'd like to see all of the province inside Cambodia Country. and i had use your file HERE. and i download the Cambodia Country , But sadly i still need to understand more how can you have Custom Map , CHN from ?
I'm very basic oon this one. So your guiadance is really critical for us and really appreciated all your support so far.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
132 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |