Joe Durand on 01 Apr 2015 01:09:42
I work in the Real Estate industry and receive requests to plot data points on map showing sales in which our company has participated. Everything went fine until I tried viewing all the data points and ended up with "Showing a Representative Sample". I would like the ability to show a minimum of 2500 data points
- Comments (50)
RE: Allow more data points to be displayed on a map
It will be good to have as this is limiting the effectiveness of power bi at the moment.
RE: Allow more data points to be displayed on a map
Hi, if not all the points can be displayed it would be nice to get a warning so people will not think their source is not reliable.
RE: Allow more data points to be displayed on a map
Agreed. Same comment regarding scatter plots. Need more data points to be visible.
RE: Allow more data points to be displayed on a map
Building a custom visual will allow you to set any number as a limit.
The solution to this problem is to specify a count of values that you want to show in your Visual.
this is possible by going into the capabilities and setting the 'count' property of the datareduction algorithm to whatever you want. We tried this with 100.000 and it worked fine, albeit a tad slower than usual.
It will affect performance, but otherwise it will work.
RE: Allow more data points to be displayed on a map
Maybe put this idea with this one :
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9817386-increase-number-of-points-in-chart-visualizations
RE: Allow more data points to be displayed on a map
This is a huge set-back. Additionally, when plotting the data points in a scatterplot - I do not want to feel an uncertainty that important outliers might not be shown. Please increase the limit to show all data-points whatever the limit might be.
RE: Allow more data points to be displayed on a map
I need for a new insight seriously more datapoints. Please inform the status of this idea
RE: Allow more data points to be displayed on a map
I've used Tableau to plot hundreds of thousands of points on maps and it's worked fine. Took me quite some time to work out why PowerBI wasn't looking right, turns out it's because it can only handle a small percentage of the data.
RE: Allow more data points to be displayed on a map
Agree. The data point limit is a problem for the Oil and Gas as well. There are hundreds of thousands of wells drilled in North America. Plotting their locations is essential if Power BI is to make inroads in the industry.
RE: Allow more data points to be displayed on a map
Agreed. I work at a utilities company with tens of thousands of assets and often when I try to plot the data points on the map I run into the limit. Also the plotting should be optimised, because often it is very slow when I'm not using gps lat/long but postal codes or city names (in Europe, the maps visual seems optimised for USA locations or something, the world is bigger than that people ;-) Maybe its possible for the PBI service to cache or pre render the maps so that it performs better. I also would like a sattelite view.