Skip to main content

Power BI

Under Review

Allow more data points to be displayed on a map

Vote (772) Share
Joe Durand's profile image

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 (48)
Joe Durand's profile image Profile Picture

Alex Alex on 16 Aug 2020 03:57:26

RE: Allow more data points to be displayed on a map

Agreed. Same comment regarding scatter plots. Need more data points to be visible.

Joe Durand's profile image Profile Picture

Power BI User on 16 Aug 2020 03:55:53

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.

Joe Durand's profile image Profile Picture

Perrine Martin on 16 Aug 2020 03:55:19

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

Joe Durand's profile image Profile Picture

Power BI User on 16 Aug 2020 03:55:15

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.

Joe Durand's profile image Profile Picture

Norbertus van der Lei on 16 Aug 2020 03:55:14

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

Joe Durand's profile image Profile Picture

Power BI User on 16 Aug 2020 03:55:06

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.

Joe Durand's profile image Profile Picture

rogerm at fuzeium on 16 Aug 2020 03:55:01

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.

Joe Durand's profile image Profile Picture

Mike on 16 Aug 2020 03:54:12

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.

Joe Durand's profile image Profile Picture

Averina Maria on 16 Aug 2020 03:52:49

RE: Allow more data points to be displayed on a map

'+1

Joe Durand's profile image Profile Picture

Vitali Kaiser on 16 Aug 2020 03:52:44

RE: Allow more data points to be displayed on a map

In my case it also would be ok if 1.000 points would be sampled and if you zoom a fitler with the lat/lon is aplied and you see a new sampling of the current view