Map Visual doesn't display data consistently?

[heathernicole]

I have created a report that looks at Sales By Shipping Postal Code By Rep.

If I have the year and a month select (May) - but no reps selected (just default to all) - My map visual looks like this: 

WITH Month Filter

If I DESELECT the Month and want to see Sales for the whole year for all reps - the visual changes and looks like this:

ONLY Year Filter - all reps and all months

IT looks as if there are NO sales in the middle of the US or the West Coast when in actuall

[hallingmoens · Accepted solution]

Hi there,

We had the same experience with plotting data on a map, when we filtered the data the map was ok and we saw the right values at the right place, but when we did not filter the data there were less data.

the unfiltered set consists of 8000 items.

It looks like there is a problem with showing larger data sets on the map visual.

[Sean]

Can you post some sample data? How many tables are you using and how are they related?

I created just a small test file and seems to work fine for me...

[heathernicole]

@Sean  - Sure! Here's some Copy and Paste Data: ( I had to change sales rep name to their number).

SalesTxn Shipping Address Postal Code	Sales Line Sales Amount	Sales Rep Initial
	613.35	14400
	0	7500
	-852.25	8225
	4735.88	8506
	888.69	8608
	0	8609
	-1474.64	8907
	900	8909
	625.23	8915
	588.5	8916
00725-3740	510	8405
969	1279.33	8405
969	0	8907
1085	973.91	8609
1230	0	8609
1523	318.43	8909
1566	560	8225
1752	119.48	8916
1801	433.75	8907
2021	446.13	8609
2021	0	8909
2038	98.97	8916
2125	310.72	8225
2129	0	8225
2452	219.48	8108
02745-6035	0	8909
2907	0	8405
2917	867.25	8916
3053	1021.44	8915
3079	0	8108
03079-4812	59.02	8608
3103	0	8907
3109	637	8907
03109-5907	0	8907

And here's a screen shot sample of the data I'm using: 

[Sean]

@heathernicole What date field do you use for the Slicers is in a Calendar table?

There must also be a date for each sales line?

[heathernicole]

@Sean - Slicers from Calendar Table

• Transaction Date Year Number
• Transaction Date Month Name

Every Sales Item is tied to a Transaction Date - there's a relationship between the Sales Details Table and the Calendar - Transaction Table.

Here's the same data with the Transaction Date added to the Grid -

[Sean]

@heathernicole I can't duplicate this.

Tries all slicers - clear - select - clear - select - No issues!

[heathernicole]

hmmm... ok. I'll try a couple of other things..

[Sean]

@dbadmin What happened here?

[heathernicole]

@Sean 

Hey! I haven't been able to work on it today - I had to work in my other position today so I haven't had time to troubleshoot that anymore. I probably won't be able to get to it until Tuesday or Wednesday of next week, unfortunately. 😞 

Thank you for checking in!

[Sean]

@heathernicole One thing we didn't discuss was what fields are you plotting?

Here's what I plotted with the data (ZipCode - I changed the name of the column because it was too long)

Just for your reference whenever you get to it...