Forum Discussion
Map Visual doesn't display data consistently?
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 - 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:
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?
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 -
heathernicole I can't duplicate this.
Tries all slicers - clear - select - clear - select - No issues!
hmmm... ok. I'll try a couple of other things..