Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello folks,
Would really appreciate your assistance on this one.
I have a set of data which basiclly represent the number of people within sub-districts. I've reflected my data as a shape map after uploading my .JASON and it looks fine. Only issue is that im unable to see the names of the sub-districts and there isnt some sort of a legend or color scale which would actually reflect how many people live in each sub-districts without hovering the mouse over them.
please provide very simple steps as this is my day 1 with power BI.
Regards,
Rad.
Solved! Go to Solution.
@Murad Yep, you can do this. You need to build that range of values. The most straightforward way is to build a calculated column. Here is just a quick example I threw together from a sample data set. Let me know if you have additional questions.
Hi murad
could please tell me how you got the sub district layers with boundaries
i tried to convert syria admin file as excel to topojson then add it as a custom map but only i have this shape
@Murad Does enabling the Legend under the formatting options not provide you what you want? (Format is the Paintbrush icon) This allows you to see the legend in various locations. Otherwise, you could look into the ArcGIS map, there is a lot you can do with that one.
Hello @Seth_C_Bauer,
Thanks for your response. I was losing hope that i'll never have an answer on this one.
However, I can't seem to have the legend done at all. below is a screen shot of the map I am working on based on dummy data i've feed into an excel sheet containing all Syria admin levels - original sheet and shapefiles were done by the UN. I''ve used this shape file to practice working with .JSON ones that i have to feed in, and im mostly intrested with countries which have a large number of sub-districts.
I would like to have my map look something similar to this (below) where legends are based on the population intensity- where it preferable not to have other countries appear in the map.
Could you please let me know if this is possible?
Regards,
Murad.
Hi Murad,
Do you know where can I find or how to build the shape for Hong Kong Districts? Thanks.
@Seth_C_Bauer Also, i've noticed that the ArcGIS sub-districts are not accurate and some sub-districts are either not in the right place or dont exist. so perhaps the shape map is the way to go only if i can get the legend to work ![]()
@Murad Yep, you can do this. You need to build that range of values. The most straightforward way is to build a calculated column. Here is just a quick example I threw together from a sample data set. Let me know if you have additional questions.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |