Forum Discussion
Limit 1000 values
Good.
I just killed my PC trying to test this.
----
I got the 'load more' to appear , once I changed the 'preview all rows option' to 'based on all rows' and refreshed.
----
I also changed some of the 'allow preview rows to load in background on query options but I don't know if this had any effect'.
If it doesn't work, sort the data descending (as you've already done) and choose from list OR just edit the formula bar - e.g. each ([SalesKey] = 2 or [SalesKey] = 3 or ......)
Has the 'load more' been taken away on the auto-filtering?
----
Anyway maybe I can help you get round this. You can choose a value from the dropdown and then edit it in the formula bar to replace it with what you want.
Is that what you are trying to do?
What I am trying to do is to filter various data by their id so that they do not appear, the problem is that there are many and it is done faster here than by a formula. So, for example, I can filter by id 35 or134 or 1678 or 2789 if I wanted to but it won't let me see more than id 2118.
The 'load more' been taken away on the auto-filtering, as you can ee in the foto, if we re talking of the same thing, maybe I misunderstood.
