Skip to main content

Power BI

Under Review

Allow more data points to be displayed on a map

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

1aecb260 6826-400e-84a8-2334798f25c8 on 16 Aug 2020 03:59:27

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

Any updates on this ?

Joe Durand's profile image Profile Picture

07be6b9b 29ec-4707-b2b4-2e33276e5bc3 on 16 Aug 2020 03:58:35

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

This has been under review for almost 2 years. Any status on updating it?

Joe Durand's profile image Profile Picture

c306b151 438e-4909-9096-c78e4968b6e1 on 16 Aug 2020 03:58:21

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

With this restriction Power BI is just a Small Data tool.
There should be no limit at all for maps and scatterplots. Otherwise they are useless.
The easiest workaround should be a checkbox for the limit of 3500 (shut off by accepting performance loss).
And that this feature is now requested for 2 years doesn't sound very promessing for soon changes :-(
Hopefully you guys adjust this soon. Until this we use the competitor tool.

Joe Durand's profile image Profile Picture

dd5158dc 6d86-4903-80bb-9594ab853e2b on 16 Aug 2020 03:58:02

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

Agreed. I could use 10,000 minimum

Joe Durand's profile image Profile Picture

a737c688 b6e6-4b32-83fe-625d388d1daf on 16 Aug 2020 03:57:38

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.

Joe Durand's profile image Profile Picture

f9833d8d 3966-427a-bdae-733564450a13 on 16 Aug 2020 03:57:37

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.

Joe Durand's profile image Profile Picture

9856b604 c8ef-468c-8a9e-c0ac6be17850 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

21f8e0fd 395b-4667-9364-121dbe1f8efe 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

f0688fd9 cad0-420b-9bb3-6a48adb8bdff 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

1436e52e f671-48e7-adc0-fe400fb7f1e4 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.