The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear all,
we are trying to build a filled map in PBI that displays the sales areas of our account managers in Germany. We cannot use the CRM dataset because that would only show us where our account managers have customers. We want to display the sales area regardless of whether we have accounts in every corner of the sales area. You can find sample data below.
I have put the zip code in the location field and the account manager name (field LTC AM) in the legend field. There are 3 issues:
Lastly I also tried to create a map within Excel. I have seen videos of people using postal code and it looked really simple but when I use postal code it's asking for coordinates. It would be great if someone could show how to create the map in Excel. Many thanks in any case!
Please let me know in case of any questions. Thanks a lot for your help!
Best regards
Zip code | LTC AM | Country |
01067 | AM1 | Germany |
01069 | AM1 | Germany |
01097 | AM1 | Germany |
01099 | AM1 | Germany |
01108 | AM1 | Germany |
01109 | AM1 | Germany |
01127 | AM1 | Germany |
01129 | AM1 | Germany |
01139 | AM1 | Germany |
01156 | AM1 | Germany |
01157 | AM1 | Germany |
01159 | AM1 | Germany |
01169 | AM1 | Germany |
01187 | AM1 | Germany |
01189 | AM1 | Germany |
01217 | AM1 | Germany |
01219 | AM1 | Germany |
01237 | AM1 | Germany |
01239 | AM1 | Germany |
07318 | AM10 | Germany |
07330 | AM10 | Germany |
07333 | AM10 | Germany |
07338 | AM10 | Germany |
07343 | AM10 | Germany |
07349 | AM10 | Germany |
07356 | AM10 | Germany |
07366 | AM10 | Germany |
07368 | AM10 | Germany |
07381 | AM10 | Germany |
07387 | AM10 | Germany |
07389 | AM10 | Germany |
07407 | AM10 | Germany |
07422 | AM10 | Germany |
55122 | AM11 | Germany |
55124 | AM11 | Germany |
55126 | AM11 | Germany |
55127 | AM11 | Germany |
55128 | AM11 | Germany |
55129 | AM11 | Germany |
55130 | AM11 | Germany |
55131 | AM11 | Germany |
55218 | AM11 | Germany |
55232 | AM11 | Germany |
55234 | AM11 | Germany |
55237 | AM11 | Germany |
55239 | AM11 | Germany |
55246 | AM11 | Germany |
55252 | AM11 | Germany |
55257 | AM11 | Germany |
55262 | AM11 | Germany |
40227 | AM12 | Germany |
40229 | AM12 | Germany |
40231 | AM12 | Germany |
40233 | AM12 | Germany |
40235 | AM12 | Germany |
40237 | AM12 | Germany |
40239 | AM12 | Germany |
40468 | AM12 | Germany |
40470 | AM12 | Germany |
40472 | AM12 | Germany |
40474 | AM12 | Germany |
40476 | AM12 | Germany |
40477 | AM12 | Germany |
40479 | AM12 | Germany |
21683 | AM13 | Germany |
21684 | AM13 | Germany |
21698 | AM13 | Germany |
21702 | AM13 | Germany |
21706 | AM13 | Germany |
21709 | AM13 | Germany |
21710 | AM13 | Germany |
21712 | AM13 | Germany |
21714 | AM13 | Germany |
21717 | AM13 | Germany |
21720 | AM13 | Germany |
21723 | AM13 | Germany |
21726 | AM13 | Germany |
21727 | AM13 | Germany |
21729 | AM13 | Germany |
21730 | AM13 | Germany |
21732 | AM13 | Germany |
21734 | AM13 | Germany |
21737 | AM13 | Germany |
21739 | AM13 | Germany |
10315 | AM14 | Germany |
10317 | AM14 | Germany |
10318 | AM14 | Germany |
10319 | AM14 | Germany |
10365 | AM14 | Germany |
10367 | AM14 | Germany |
10369 | AM14 | Germany |
10405 | AM14 | Germany |
10407 | AM14 | Germany |
10409 | AM14 | Germany |
10435 | AM14 | Germany |
10437 | AM14 | Germany |
10439 | AM14 | Germany |
10551 | AM14 | Germany |
10553 | AM14 | Germany |
56761 | AM2 | Germany |
56766 | AM2 | Germany |
56767 | AM2 | Germany |
56769 | AM2 | Germany |
56812 | AM2 | Germany |
56814 | AM2 | Germany |
56818 | AM2 | Germany |
56820 | AM2 | Germany |
56821 | AM2 | Germany |
56823 | AM2 | Germany |
56825 | AM2 | Germany |
56826 | AM2 | Germany |
56828 | AM2 | Germany |
56829 | AM2 | Germany |
56841 | AM2 | Germany |
34326 | AM3 | Germany |
34327 | AM3 | Germany |
34537 | AM3 | Germany |
34549 | AM3 | Germany |
34560 | AM3 | Germany |
34576 | AM3 | Germany |
34582 | AM3 | Germany |
34587 | AM3 | Germany |
34590 | AM3 | Germany |
34593 | AM3 | Germany |
34596 | AM3 | Germany |
34599 | AM3 | Germany |
34613 | AM3 | Germany |
34621 | AM3 | Germany |
34626 | AM3 | Germany |
34628 | AM3 | Germany |
20095 | AM4 | Germany |
20097 | AM4 | Germany |
20099 | AM4 | Germany |
20144 | AM4 | Germany |
20146 | AM4 | Germany |
20148 | AM4 | Germany |
20149 | AM4 | Germany |
20249 | AM4 | Germany |
20251 | AM4 | Germany |
20253 | AM4 | Germany |
20255 | AM4 | Germany |
20257 | AM4 | Germany |
20259 | AM4 | Germany |
20354 | AM4 | Germany |
20355 | AM4 | Germany |
20357 | AM4 | Germany |
68809 | AM5 | Germany |
69115 | AM5 | Germany |
69117 | AM5 | Germany |
69118 | AM5 | Germany |
69120 | AM5 | Germany |
69121 | AM5 | Germany |
69123 | AM5 | Germany |
69124 | AM5 | Germany |
69126 | AM5 | Germany |
69151 | AM5 | Germany |
69168 | AM5 | Germany |
69181 | AM5 | Germany |
69190 | AM5 | Germany |
69207 | AM5 | Germany |
69214 | AM5 | Germany |
35094 | AM6 | Germany |
35096 | AM6 | Germany |
35099 | AM6 | Germany |
35102 | AM6 | Germany |
35104 | AM6 | Germany |
35108 | AM6 | Germany |
35110 | AM6 | Germany |
35112 | AM6 | Germany |
35114 | AM6 | Germany |
35116 | AM6 | Germany |
35117 | AM6 | Germany |
35119 | AM6 | Germany |
35216 | AM6 | Germany |
35232 | AM6 | Germany |
35236 | AM6 | Germany |
35239 | AM6 | Germany |
35260 | AM6 | Germany |
72145 | AM7 | Germany |
72147 | AM7 | Germany |
72149 | AM7 | Germany |
72172 | AM7 | Germany |
72181 | AM7 | Germany |
72184 | AM7 | Germany |
72186 | AM7 | Germany |
72189 | AM7 | Germany |
72336 | AM7 | Germany |
72348 | AM7 | Germany |
72351 | AM7 | Germany |
72355 | AM7 | Germany |
72356 | AM7 | Germany |
72358 | AM7 | Germany |
30455 | AM9 | Germany |
30457 | AM9 | Germany |
30459 | AM9 | Germany |
30519 | AM9 | Germany |
30521 | AM9 | Germany |
30539 | AM9 | Germany |
30559 | AM9 | Germany |
30625 | AM9 | Germany |
30627 | AM9 | Germany |
30629 | AM9 | Germany |
30655 | AM9 | Germany |
30657 | AM9 | Germany |
80687 | AM8 | Germany |
80689 | AM8 | Germany |
80796 | AM8 | Germany |
80797 | AM8 | Germany |
80798 | AM8 | Germany |
80799 | AM8 | Germany |
80801 | AM8 | Germany |
80802 | AM8 | Germany |
80803 | AM8 | Germany |
80804 | AM8 | Germany |
80805 | AM8 | Germany |
80807 | AM8 | Germany |
80809 | AM8 | Germany |
80933 | AM8 | Germany |
80935 | AM8 | Germany |
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
51 | |
51 | |
46 |