Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
KMZ_ESS
Helper I
Helper I

Filled map doesn't load fully

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:

  1. the map only loads 4 sales areas (and at least one of them is only loaded partially)
  2. the legend only displays 7 account managers; when I put the LTC AM field also in the tooltips field, the legend shows all account managers (but the areas still don't load further)
  3. the map loads very slowlyCan anyone help me build this filled map showing all account managers and sales areas? 

 

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 

 

PBI MS Forum.png

 

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

 

0 REPLIES 0

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors