Forum Discussion
OliverDilg
2 years agoRegular Visitor
create user defined heat map with .json file
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 unab...
vanessafvg
Community Champion
2 years agocan you share the file? and give an example of a picture of what you want to achieve
- OliverDilg2 years agoRegular Visitor
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/
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)?
- vanessafvg2 years ago
Community Champion
then just provide a subset, its impossible to help without a sample of the data
- OliverDilg2 years agoRegular Visitor
Hello, here are some datas.
The whole list has over 8000 Postcodes.
Is it this what you need?
many thanks!
PLZ Sales MΔ 47447 -59.421,110 91052 -58.378,450 78573 -57.850,472 58644 -56.445,741 85072 -53.275,000 01609 -53.084,301 91601 -52.089,981 75181 -49.796,680 12057 -49.166,531 44532 -46.785,081 12489 -45.182,551 10969 -45.133,729 30419 -44.965,761 35041 -44.558,080 79790 -43.296,390 63450 -42.732,979 61440 -41.780,389 58840 -40.980,889 04575 -40.797,779 51143 -39.308,360 58706 -35.405,000 26655 -35.385,960 73054 -34.932,670 08523 -34.625,820 90441 -32.850,631 33129 -30.886,512 04509 -30.258,970 58762 -30.054,420 42499 -29.633,221 40589 -29.424,130 42859 -29.326,520 09653 -28.749,000 63110 -28.240,780 65189 -27.016,830 34286 -26.411,231 94121 -26.092,919 86405 -25.806,869 48268 -25.516,191 57299 -25.479,561 57365 -25.270,551 84048 -25.142,100 20457 -24.975,980 49685 -24.623,020 27321 -24.152,540 58119 -23.955,823 86807 -23.786,430 69120 -23.141,420 89275 -22.883,270 60314 -22.863,650 70736 -22.695,110 05600 -22.563,850 98693 -22.456,819 49661 -22.390,180 59368 -22.347,290 71701 -21.788,461 84508 -21.766,210 79618 -21.465,900 13439 -20.232,050 33054 -19.616,940 01920 -19.420,870 39122 -19.306,511 97076 -19.289,980 49504 -18.988,021 52382 -18.964,720 76761 -18.899,880 91126 -18.631,780 21509 -18.339,111 58099 -18.207,651 88690 -17.860,901 48599 -17.855,120 74382 -17.848,941 01894 -17.701,369 35260 -17.337,059 26904 -17.127,569 19306 -16.969,350 63069 -16.871,780 76744 -16.822,400 74360 -16.822,079 47138 -16.777,110 01328 -16.391,810 72762 -16.370,871 44147 -16.364,181 59969 -15.903,080 45473 -15.836,440 84030 -15.676,810 67283 -15.655,669 64287 -15.581,080 77709 -15.413,890 01189 -15.262,200 76552 -15.252,850 98617 -15.037,970 71272 -15.003,800 53177 -14.510,710 73062 -14.504,900 24768 -14.227,170 83052 -13.999,380 59721 -13.859,720 02070 -13.777,660 77972 -13.745,630 48565 -13.742,219 74889 -13.603,120 66333 -13.552,410 04603 -13.542,380 94330 -13.412,990 50226 -13.279,340 01187 -13.116,160 27318 -13.115,419 42897 -12.785,130 27798 -12.489,720 29699 -12.394,780 46519 -12.384,540 34508 -12.347,359 66748 -12.250,220 79104 -12.230,330 13125 -12.180,400 74321 -12.101,570 40599 -12.092,880 95326 -12.078,210 73107 -11.941,480 58553 -11.845,550 09618 -11.753,680 52222 -11.654,210 26607 -11.576,690 66538 -11.528,741 12347 -11.461,420 21255 -11.289,900 03226 -11.220,100 23560 -11.217,870 49716 -11.185,860 26388 -11.149,890 04178 -11.066,750 31177 -10.897,440 86650 -10.894,400 80809 -10.847,930 22851 -10.784,140 61169 -10.463,400 06461 -10.447,740 36041 -10.426,571 87509 -10.378,729 45884 -10.172,870 61267 -10.123,030 94234 -10.083,080 97285 -10.074,750 78655 -9.948,460 83278 -9.890,000 01705 -9.714,278 48619 -9.691,620 48683 -9.658,869 77761 -9.650,010