Increase number of points in chart visualizations.
I deal with a great amount of time-series data (100'000 records for tens of series) and the limit of 1000 points in line charts is very restrictive to me, particularly when the series belong to 10 or more different series (each series is undersampled to 100 (1000/10) or less points making a very zig-zagged chart).
Other commercial software can manage up to 30x10^6 points in a chart. Is it possible to increase this 1000 points limitation, let's say, to 100'000 points?
Please, Increase number of points in chart visualizations
Jeff K commented
I am mapping 200,000 earthquakes: Tableau can display all of them easily, Power BI cannot, so I get only a sample of my earthquake locations.
This is really needed soon, please! Because of the limitations I can't make make such line chart visuals I want with Power BI. For example Power Pivot works fine, why not Power BI?
Mike Honey commented
It's great we now have a Ribbon chart and all, but it's disappointing to see fundamental issues like this ignored for years. And where is the documentation of what the current limits actually are? As I understand it they vary by visual.
This is really a blocking issue for me too!
This needs to be fixed. Tableau is far better at this. They allow so much more data points per chart/graph.
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.
I am currently developing a custom visual for a customer and I am also running into a 1000 item limit when I need 10,000 - 100,000 points of data.
This is very frustrating.
This is a MUST !
No need to mention that we can easily face situations where more than 3500 data points need to be displayed.
Do you have any updates please ?
Completely agree! I can't even demo Power BI to management because of this issue!
this needs to be added
Simon Hetzel commented
Also we need min/max/avg **per series**. I can do this with a trendline, why not min/max etc.?
Uzi Cohen commented
This is MUST for a reliable BI reporting tool.
missing data points make it unreliable.
Edwin Kruger commented
We keep having this problem in the map visual. We have areas with more than 1000 addresses that need to be shown on the map individually.
Cliff Brandon commented
I have US county and Parish names. It would be great if Bing would recognize them. I do realize that this would mean dealing with a political subregion below state for other places in the world but I can't imagine Bing doesn't have those polygons.
Greg Hyzak commented
All "hard stop limits" within the tool should be configurable. Setting these makes the tool unusable in certain situations. Let end users gauge and set these limits appropriately!
I need all days between 2008 and now and 10 lines in the graph. Coudnt visualize this. Please upgrade
Callum Green commented
Very limited, especially if you are trying to incorporate the full capabilities of stream analytics.
Tim Kent commented
This limit makes Power BI useless for any type of chart that has max and min values that can't be randomly removed from the data set (e.g stress data).