Forum Discussion
Too many values error in map
If you are looking to display where your customers mostly are (and not individual customers), you can try the filled map and use color intensities together with counts.
Unfortunately the inteded result is pinpoint location of the customer with visual representation of the ABC status to serve as tool for field sales to plan their visits in the area... so no, filled map won't do.
I'd rather make this work in Power Bi than code specifically using google/Bing Map api... but seems we hit the roof here :smileysad:
pinky - I haven't ever tried to pin down the exact limits on the visuals and I know of no documentation that specifies the exact limit, the impression that I get is that it is somewhat situational. Also, map visuals are not the only ones that do this so I do not think it is necessarily tied to geocoding. Pie charts and other visuals also exhibit this behavior.
This is an interesting problem. What if you didn't get that "too many values" error? Would the display of all those bunched up little circles help you? If you zoomed out, there would be circles on top of each other. If you zoomed in, maybe you would need a gigantic monitor to be able to view them separately.
How about two maps? With one you could zoom the other. Read about it here: http://tinyurl.com/pb372qn.
I thought of this solution with a drill down reporrt asocorro already, unfortunately the data relate to Germany and there is no state / region to use to break it down further. Indeed with high zoom all is drawn on top of each other so it does not give any info, but it's to be used with high zoom for field sales trip planning as mentioned... this is the idea at least.
The problem is that with zoom change the dataset is not refreshed, so indeed, I do not mind not seeing couple of hundreds points in top zoom where they all just create one big spot.... but when zoomed down they need to be shown. Would it be possible to refresh for data just in the area shown then it is all sorted ofcourse as theer can be around 20 or so points.. but that is not the case unfortunately... I'm probably trying BIMap to do something it has not really been designed for. Should the data be somehow consolidated, theer is no problem, but as it is customer level I'm breaking it on and so many customers.... here we are. :smileyindifferent:
pinky - What is the location data, is it city or geocoordinates or something else? Thought would be that you could create a calculated column that essentially consolidated the data in some manner where everything in a certain area all has the same location code for example?
