Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an Azure Map in my Power BI Desktop file and I want to color code the US states according to my companies regions. To do this I am using a 'reference layer' which gets its JSON from a file I have provided. I decided to first experiment with a layer that just defines the state of Colorado in the USA. and I sourced the JSON polygon coordinates from available GeoJSON repositiories on Github.
It works fine in highlighting Colorado- which is shaded blue. But I did not choose the color blue. And I can find no place where the color blue is set in the Azure Map menus. And my GEOJSON code for Colorado has no attribute relating to color. So what determines that Colorado is showing blue? In my main JSON theme file (provided by my company) there are plenty of places where colors are specified, but I can find no tags that would relate to Azure Maps.
Can anyone tell me what JSON elements would result in making Colorado blue? Thanks. - John
Solved! Go to Solution.
Hey John,
I believe the Azure Maps Visual defaults to blue if you don't specify the fill color and stroke color in your GeoJSON. Here is an example of the properties you need to set: "fillColor":"rgb(255,0,0)","stroke-width":"3","stroke": "#555555"
{"type":"FeatureCollection","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"}},"features":[{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[-109.06018824156149,38.2755269021159],[-109.06011924196429,38.500016502497424],[-109.05982744220965,38.715593402879044],[-109.05396514174998,38.88200710313349],[-109.05262064224317,39.0026547033935],[-109.05155284181106,39.11057730355151],[-109.0514859415767,39.1157440035784],[-109.05115844187422,39.20654090367074],[-109.0508346423324,39.36655700396887],[-109.05122234173552,39.49780640421703],[-109.05128564152223,39.66917170443636],[-109.0509483420983,40.22277850532463],[-109.05092704214451,40.306172505494594],[-109.05089184166,40.33561900551647],[-109.05109304182638,40.453789105741805],[-109.05074714193188,40.47968610577637],[-109.04802384164736,40.580624805879914],[-109.04867434228936,40.65527130599219],[-109.04882294160412,40.74695890616865],[-109.04870834172632,40.77153660623534],[-109.04866994234106,40.79247680622116],[-109.04845554232985,40.826081906306904],[-109.04850834170918,40.83208410628812],[-109.04883134175037,40.848021706291966],[-109.04904504197397,40.89390270638447],[-109.04923944189363,40.906239106419704],[-109.05002774230401,41.000690106540425],[-107.91539863830805,41.00082560654845],[-107.31780283693898,41.00290880655762],[-107.13536603616888,41.003036106572985],[-107.0315128353155,41.00340030657416],[-106.8577733354056,41.00266310652872],[-106.58079233435211,41.001932106539506],[-106.45795953350623,41.002093806529636],[-106.36905073361407,41.00048830653992],[-106.35259543371387,41.00001900653346],[-106.32127293316984,40.99931110658408],[-106.19056463274606,40.997544306580835],[-106.08787983285714,40.99737270654582],[-105.6669235311978,40.99701510656456],[-105.47893673107413,40.99775410652407],[-105.27686032998538,40.998172106530006],[-104.94337562886194,40.99823990658217],[-104.85520072920303,40.998069506564455],[-104.60670022772199,41.001518806549086],[-104.05321422671591,41.00167980655304],[-103.574066924773,41.00173000655268],[-102.62055362196823,41.00213590653214],[-102.05157792016385,41.00236010655477],[-102.05175662022724,40.00306250496861],[-102.04980972037049,39.57395790432998],[-102.0497641200899,39.56817010432884],[-102.0470479200894,39.13379070357641],[-102.04651401987333,39.04539640344389],[-102.04535492006535,38.695238702835],[-102.0445683201658,38.26881910210092],[-102.0445110202269,38.26248340211102],[-102.04199031968399,37.73854070117468],[-102.04158531962678,37.64428210101002],[-102.04158612002568,37.389190500537616],[-102.04212741966477,36.993127599873375],[-102.26271962056339,36.994832399854616],[-102.69763582173181,36.995121799831324],[-102.74190302220441,36.99762389986227],[-102.75858962212133,36.99991599985216],[-102.97972592270779,36.99873229983627],[-103.00224842339472,37.00020649987968],[-103.08617282300095,36.99835359986901],[-104.00785692603249,36.99690969986928],[-104.48328662741552,36.9937684998168],[-105.14314393009349,36.99513119986862],[-105.22061293004657,36.99500979985009],[-105.64129503084608,36.99573649988681],[-105.71920443166522,36.99583659984417],[-106.00663473225607,36.995343199831886],[-106.02391393280149,36.99521009983976],[-106.07403233235343,36.99495049984717],[-106.14662383243805,36.99473639988445],[-106.16385053274314,36.99446349987959],[-106.47708553373768,36.99375589984149],[-106.86979633510369,36.9924260998427],[-106.87729233510036,37.00013909989491],[-106.98551333532167,37.0001300998673],[-107.1968898364726,37.0000060998408],[-107.42091533641411,37.00000009985985],[-107.47793683709357,37.000100699846215],[-108.37964433952153,37.00004299987109],[-109.04520184166563,36.998973499892614],[-109.04549644236734,37.24041320032925],[-109.04577754228862,37.323846900478465],[-109.04577384212794,37.33079870042539],[-109.0456560415528,37.356347600492576],[-109.04524164152441,37.400998400607186],[-109.04360274164021,37.47605600069581],[-109.0427144416704,37.50965330075352],[-109.04216284194824,37.533375600830624],[-109.04190434184295,37.61214890094852],[-109.04199504204253,37.879213301441226],[-109.04258314211143,38.153026701902675],[-109.04283684161983,38.16627020191974],[-109.06018824156149,38.2755269021159]]]]},"properties":{"tag":"Test","name":"Test","fillColor":"rgb(255,0,0)","stroke-width":"3","stroke": "#555555","metadata":"{\"type\":\"markup-builder\",\"subType\":\"territory\",\"territoryIdColumnName\":\"ISO2\",\"territoryIds\":[\"US-CO\"],\"centroidWkts\":null,\"territoryIdHistory\":[],\"holesRemoved\":true,\"layerId\":\"fc0bd68e-54af-4144-90e1-9b79c9465aca\",\"countryCode\":null,\"labelPoint\":{\"_x\":-11749870.93235,\"_y\":4725447.163705}}","azureKey":null,"col1":"Test"}}]}
Results in:
If you really want to get fancy, you can use Territory Visual by EasyTerritory to build your regions & territories and then bind them to metrics in your data model to build interactive heat maps.
Hope this helps!
Benton (from EasyTerritory)
Thanks very much Benton! I will dig into the code you provided and see if I can get it to work. I'll also check out the Easy Territory visuals. I appreciate your efforts here. -John
Hey John,
I believe the Azure Maps Visual defaults to blue if you don't specify the fill color and stroke color in your GeoJSON. Here is an example of the properties you need to set: "fillColor":"rgb(255,0,0)","stroke-width":"3","stroke": "#555555"
{"type":"FeatureCollection","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:OGC:1.3:CRS84"}},"features":[{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[-109.06018824156149,38.2755269021159],[-109.06011924196429,38.500016502497424],[-109.05982744220965,38.715593402879044],[-109.05396514174998,38.88200710313349],[-109.05262064224317,39.0026547033935],[-109.05155284181106,39.11057730355151],[-109.0514859415767,39.1157440035784],[-109.05115844187422,39.20654090367074],[-109.0508346423324,39.36655700396887],[-109.05122234173552,39.49780640421703],[-109.05128564152223,39.66917170443636],[-109.0509483420983,40.22277850532463],[-109.05092704214451,40.306172505494594],[-109.05089184166,40.33561900551647],[-109.05109304182638,40.453789105741805],[-109.05074714193188,40.47968610577637],[-109.04802384164736,40.580624805879914],[-109.04867434228936,40.65527130599219],[-109.04882294160412,40.74695890616865],[-109.04870834172632,40.77153660623534],[-109.04866994234106,40.79247680622116],[-109.04845554232985,40.826081906306904],[-109.04850834170918,40.83208410628812],[-109.04883134175037,40.848021706291966],[-109.04904504197397,40.89390270638447],[-109.04923944189363,40.906239106419704],[-109.05002774230401,41.000690106540425],[-107.91539863830805,41.00082560654845],[-107.31780283693898,41.00290880655762],[-107.13536603616888,41.003036106572985],[-107.0315128353155,41.00340030657416],[-106.8577733354056,41.00266310652872],[-106.58079233435211,41.001932106539506],[-106.45795953350623,41.002093806529636],[-106.36905073361407,41.00048830653992],[-106.35259543371387,41.00001900653346],[-106.32127293316984,40.99931110658408],[-106.19056463274606,40.997544306580835],[-106.08787983285714,40.99737270654582],[-105.6669235311978,40.99701510656456],[-105.47893673107413,40.99775410652407],[-105.27686032998538,40.998172106530006],[-104.94337562886194,40.99823990658217],[-104.85520072920303,40.998069506564455],[-104.60670022772199,41.001518806549086],[-104.05321422671591,41.00167980655304],[-103.574066924773,41.00173000655268],[-102.62055362196823,41.00213590653214],[-102.05157792016385,41.00236010655477],[-102.05175662022724,40.00306250496861],[-102.04980972037049,39.57395790432998],[-102.0497641200899,39.56817010432884],[-102.0470479200894,39.13379070357641],[-102.04651401987333,39.04539640344389],[-102.04535492006535,38.695238702835],[-102.0445683201658,38.26881910210092],[-102.0445110202269,38.26248340211102],[-102.04199031968399,37.73854070117468],[-102.04158531962678,37.64428210101002],[-102.04158612002568,37.389190500537616],[-102.04212741966477,36.993127599873375],[-102.26271962056339,36.994832399854616],[-102.69763582173181,36.995121799831324],[-102.74190302220441,36.99762389986227],[-102.75858962212133,36.99991599985216],[-102.97972592270779,36.99873229983627],[-103.00224842339472,37.00020649987968],[-103.08617282300095,36.99835359986901],[-104.00785692603249,36.99690969986928],[-104.48328662741552,36.9937684998168],[-105.14314393009349,36.99513119986862],[-105.22061293004657,36.99500979985009],[-105.64129503084608,36.99573649988681],[-105.71920443166522,36.99583659984417],[-106.00663473225607,36.995343199831886],[-106.02391393280149,36.99521009983976],[-106.07403233235343,36.99495049984717],[-106.14662383243805,36.99473639988445],[-106.16385053274314,36.99446349987959],[-106.47708553373768,36.99375589984149],[-106.86979633510369,36.9924260998427],[-106.87729233510036,37.00013909989491],[-106.98551333532167,37.0001300998673],[-107.1968898364726,37.0000060998408],[-107.42091533641411,37.00000009985985],[-107.47793683709357,37.000100699846215],[-108.37964433952153,37.00004299987109],[-109.04520184166563,36.998973499892614],[-109.04549644236734,37.24041320032925],[-109.04577754228862,37.323846900478465],[-109.04577384212794,37.33079870042539],[-109.0456560415528,37.356347600492576],[-109.04524164152441,37.400998400607186],[-109.04360274164021,37.47605600069581],[-109.0427144416704,37.50965330075352],[-109.04216284194824,37.533375600830624],[-109.04190434184295,37.61214890094852],[-109.04199504204253,37.879213301441226],[-109.04258314211143,38.153026701902675],[-109.04283684161983,38.16627020191974],[-109.06018824156149,38.2755269021159]]]]},"properties":{"tag":"Test","name":"Test","fillColor":"rgb(255,0,0)","stroke-width":"3","stroke": "#555555","metadata":"{\"type\":\"markup-builder\",\"subType\":\"territory\",\"territoryIdColumnName\":\"ISO2\",\"territoryIds\":[\"US-CO\"],\"centroidWkts\":null,\"territoryIdHistory\":[],\"holesRemoved\":true,\"layerId\":\"fc0bd68e-54af-4144-90e1-9b79c9465aca\",\"countryCode\":null,\"labelPoint\":{\"_x\":-11749870.93235,\"_y\":4725447.163705}}","azureKey":null,"col1":"Test"}}]}
Results in:
If you really want to get fancy, you can use Territory Visual by EasyTerritory to build your regions & territories and then bind them to metrics in your data model to build interactive heat maps.
Hope this helps!
Benton (from EasyTerritory)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |