Forum Discussion
Missing data only appears when I select a data set in the legend
I have created a scatter graph of 3 variables. Some data seems to be missing on the orange line.
But when I select the data set in the legend, the rest of the data appears.
Why is it not showing me all the data, all the time?
6 Replies
- lbendlin
Super User
Because you have too many data points and Power BI is employing forced grouping and sampling. Use fewer data points.
Thanks.
To try this, I created a new data table which creates the daily averages of each variable (a few months of data), but the same problem occurs...- lbendlin
how many data points in the aggregated version?
The main table of my original tables has 200,000+ lines and 21 columns.
In the added table for daily averages, there are 700 lines and 10 columns.
But the displayed orange line cuts off at the same position, which makes me think it isn't a data size problem.
- lbendlin
Every visual has limits on how many data points it can display. For a line chart that can be as low as 1000 - after that you will see forced random grouping and sampling. The little blue "i" icon in the top right corner will alert you to that.
For the record, this didn't solve it, but the problem seems to have resolved itself later, after yet more data was added and a couple of weeks have gone by! No idea why.
