Limit 1000 values

[afrutos]

Hi everyone,
Is there any possibility to display all values and not havng this limit?

Thank you

[HotChilli · Accepted solution]

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 ......)

[afrutos]

Yes, that's what I did and it really works
Thanks a lot!

[afrutos]

@HotChilli I think Ifound a solution if a put it in a DESC order

[HotChilli]

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?

[afrutos]

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.

[afrutos]

Hi,
You mean here?

But as far as I can see, it doesn't change anything 😞

[HotChilli]

Click on 'column profiling based on top 1000 rows' at the bottom of the screen. Select the other option