Forum Discussion

pinky's avatar
pinky
Regular Visitor
10 years ago

Too many values error in map

Hi,  I'm building a map report with simple ABC classification of customers. PowerBI is not used for Geocoding, the geolocation data are available in the dataset so it is just drawing these.... Howev...
Need Help
pinky's avatar
pinky
Regular Visitor
10 years ago

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:

asocorro's avatar
asocorro
Skilled Sharer
10 years ago

Can't you create another filter in addition to the ABC?  Say, city, customer business type, or salesperson?  You could also resort to a map in R, where you can have more control over the map details.