Data Filter more than 10,000 unique items?

Question

Data Filter more than 10,000 unique items?

Anonymous

i have a database with 19,800 rows [and counting as I add more entries]. When I have DATA>FILTER active and try to search a column, an alert displays that "not all entries are shown". It says that the column contains more than 10,000 unique entries. Is there a way to get DATA>FILTER to search ALL the entries?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Answer 1

Ashish Mathur 101.8K Volunteer Moderator

Hi,

No, there isn't. You may sue Data > Advanced filter instead.

0 comments

Answer 2

Jeovany - Thanks for the reply. I'm not sure what you man by the "power query editor". I'm using the Filter button in the Filter and Sort section of the ribbon, under the DATA tab.

Is that what you mean?

Upon further inspection it seems that the alert is only for what is DISPLAYED in the drop-down menu, but all rows are sorted/searched etc. as requested.

Hi Jack

It seems you are using the Power Query Editor for filtering your data.

IMHO

If that's the case

No worries. in plain English,

Excel does that to save memory in the Power Query editor

Once you load your table all filtered rows will show up.

Regards

Jeovany

Answer 3

Hi Jack

It seems you are using the Power Query Editor for filtering your data.

IMHO

If that's the case

No worries. in plain English,

Excel does that to save memory in the Power Query editor

Once you load your table all filtered rows will show up.

Regards

Jeovany

Share via

Data Filter more than 10,000 unique items?

3 answers