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.
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...
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 -
