I have created an standard list with a few simple text columns.

Why can I not see the normal filter values of all columns? Instead it shows a new "Show Filter choices" link (pic 1) which when clicked brings all the values above the column names (pic 2).

How can I make the filter simply shows all distinct values which I think is default behavior and have in many other list in our portal?

enter image description here

enter image description here

  • Is it a large list ? how many items ? Commented Sep 29, 2014 at 12:02

1 Answer 1


As indicated in the comment above, when the list has over 500 items for performance reasons some fields will not display the available values and display "Show Filter Choices" instead.

If you wish you could try adding ?Filter=1 in the URL, which will show the available values by default. Not sure if it will work for you.

If you are familiar and comfortable working with Sharepoint Designer, you can also try the suggestions on MSDN which will help you open the page and modify the DataView webpart.

As always, since this is related to performance it would be a good idea to check for negative side effects before actually implementing any workarounds. You will find AJAX suggestions too if you search online for "sharepoint show filter choices".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.