Forum Discussion
Map Visual doesn't display data consistently?
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
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.
10 Replies
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?
