create user defined heat map with .json file

Question

Hello, i´tryin to find an .jason file which include all post codes from Germany to import this map in Power BI Desktop to create a heat map by postcode level.

I found some .json file, but I was unable to import any of them.

Did everyone try to do this in Power BI, or ist there a visual i can use for this?

kind regards and many thanks

Oliver

vanessafvg · Answer

can you share the file? and give an example of a picture of what you want to achieve

oliverdilg · Answer

Hello, i can' t upload the .json file because it´s too big, > 200 MB.

I tried files from different links->

https://www.jsonbix.com/karten-vorlagen/europa/deutschland/plz-postleitzahlen/

https://www.suche-postleitzahl.org/plz-karte-erstellen

https://www.jsonbix.com/karten-vorlagen/europa/

https://hub.arcgis.com/datasets/esri-de-content::postleitzahlengebiete-in-deutschland/explore?location=50.858449%2C12.995199%2C6.68

But non of them worked for me.

I wanted to creat such map in Power BI.

Sales differenc by postcode level.

Is there any Power BI map visual i can use for Germany (5 digits post codes)?

vanessafvg · Answer

then just provide a subset, its impossible to help without a sample of the data

oliverdilg · Answer

Hello, here are some datas.The whole list has over 8000 Postcodes.Is it this what you need?many thanks!&nbsp;PLZSales MΔ47447-59.421,11091052-58.378,45078573-57.850,47258644-56.445,74185072-53.275,00001609-53.084,30191601-52.089,98175181-49.796,68012057-49.166,53144532-46.785,08112489-45.182,55110969-45.133,72930419-44.965,76135041-44.558,08079790-43.296,39063450-42.732,97961440-41.780,38958840-40.980,88904575-40.797,77951143-39.308,36058706-35.405,00026655-35.385,96073054-34.932,67008523-34.625,82090441-32.850,63133129-30.886,51204509-30.258,97058762-30.054,42042499-29.633,22140589-29.424,13042859-29.326,52009653-28.749,00063110-28.240,78065189-27.016,83034286-26.411,23194121-26.092,91986405-25.806,86948268-25.516,19157299-25.479,56157365-25.270,55184048-25.142,10020457-24.975,98049685-24.623,02027321-24.152,54058119-23.955,82386807-23.786,43069120-23.141,42089275-22.883,27060314-22.863,65070736-22.695,11005600-22.563,85098693-22.456,81949661-22.390,18059368-22.347,29071701-21.788,46184508-21.766,21079618-21.465,90013439-20.232,05033054-19.616,94001920-19.420,87039122-19.306,51197076-19.289,98049504-18.988,02152382-18.964,72076761-18.899,88091126-18.631,78021509-18.339,11158099-18.207,65188690-17.860,90148599-17.855,12074382-17.848,94101894-17.701,36935260-17.337,05926904-17.127,56919306-16.969,35063069-16.871,78076744-16.822,40074360-16.822,07947138-16.777,11001328-16.391,81072762-16.370,87144147-16.364,18159969-15.903,08045473-15.836,44084030-15.676,81067283-15.655,66964287-15.581,08077709-15.413,89001189-15.262,20076552-15.252,85098617-15.037,97071272-15.003,80053177-14.510,71073062-14.504,90024768-14.227,17083052-13.999,38059721-13.859,72002070-13.777,66077972-13.745,63048565-13.742,21974889-13.603,12066333-13.552,41004603-13.542,38094330-13.412,99050226-13.279,34001187-13.116,16027318-13.115,41942897-12.785,13027798-12.489,72029699-12.394,78046519-12.384,54034508-12.347,35966748-12.250,22079104-12.230,33013125-12.180,40074321-12.101,57040599-12.092,88095326-12.078,21073107-11.941,48058553-11.845,55009618-11.753,68052222-11.654,21026607-11.576,69066538-11.528,74112347-11.461,42021255-11.289,90003226-11.220,10023560-11.217,87049716-11.185,86026388-11.149,89004178-11.066,75031177-10.897,44086650-10.894,40080809-10.847,93022851-10.784,14061169-10.463,40006461-10.447,74036041-10.426,57187509-10.378,72945884-10.172,87061267-10.123,03094234-10.083,08097285-10.074,75078655-9.948,46083278-9.890,00001705-9.714,27848619-9.691,62048683-9.658,86977761-9.650,010&nbsp;

vanessafvg · Answer

I am not sure what you were struggling with exactly but based on the data you gave&nbsp; me i was able to do this, i used arcgis because it is quite flexible on the mapping but you need to edit the settings of arcgis itself.&nbsp;&nbsp;
&nbsp;
i set the data category of the postcodes to postcodes in power bi and then in arcgis made it specific to germany.
&nbsp;
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations-arcgis
&nbsp;
not sure if this solves your issue.&nbsp; if you have any specific questions let me know.
&nbsp;
&nbsp;

&nbsp;

Forum Discussion

create user defined heat map with .json file

5 Replies

Related content

un define

ELT JSON / Semi structured

Fabric User Define Functions

Creating a Universal JSON Theme for Power BI Reports

Power BI - Deneb visual - Read a JSON to create the visuals