Power BI User on 18 Sep 2015 23:27:03
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?
- Comments (22)
RE: Increase number of points in chart visualizations.
We need this for forecasting
RE: Increase number of points in chart visualizations.
We need this NOW as we have Load forecasting data point visualizations that Power BI doesn't provide and must use Tableau as we are wanting to migrate all to Power BI.
RE: Increase number of points in chart visualizations.
Please, Increase number of points in chart visualizations
RE: Increase number of points in chart visualizations.
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.
RE: Increase number of points in chart visualizations.
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?
RE: Increase number of points in chart visualizations.
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.
RE: Increase number of points in chart visualizations.
This is really a blocking issue for me too!
RE: Increase number of points in chart visualizations.
This needs to be fixed. Tableau is far better at this. They allow so much more data points per chart/graph.
RE: Increase number of points in chart visualizations.
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: Increase number of points in chart visualizations.
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.