A simple SharePoint custom list in office 365 has 8 columns and no special settings are enabled on it. The columns are of type choice and has 5-6 types of values present in them. The OOTB column filtering does not show all the values instead show 2-3. Can anyone help me in resolving this issue.


Column 1


Showing when filter drop down is selected

Column 1


Tried changing the type of the columns and recreating the list by saving it as a template. Both of the methods did not solve the issue.

  • How many items are in the list?
    – ghangas
    Commented Aug 17, 2017 at 16:58
  • There are only 38 items in the list @ghangas Commented Aug 18, 2017 at 14:52
  • That's not the problem then.
    – ghangas
    Commented Aug 18, 2017 at 15:19
  • Yes it's not the item threshold problem. @ghangas Commented Aug 18, 2017 at 17:52

2 Answers 2


The item filtering option will display only those values of choice field which are filled up in items. If the value from choice field is not displayed under filter it indicates that it's not being used by any item.

  • The values are filled in the items and yet doesn't show. Commented Aug 18, 2017 at 14:52
  • Did the issue happen in classic or modern view of SharePoint?
    – aearwen
    Commented Jan 22, 2020 at 8:35

The issue is due to the masterpage being customized to hide 'sharing' options in a team site. The UI element which is used for sharing is updated by Microsoft with the environment being SharePoint Online and it affected the list filtering capability.

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.