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 Aug 17 '17 at 16:58
  • There are only 38 items in the list @ghangas – Suhas Aug 18 '17 at 14:52
  • That's not the problem then. – ghangas Aug 18 '17 at 15:19
  • Yes it's not the item threshold problem. @ghangas – Suhas Aug 18 '17 at 17:52

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.

| improve this answer | |
  • The values are filled in the items and yet doesn't show. – Suhas Aug 18 '17 at 14:52
  • Did the issue happen in classic or modern view of SharePoint? – aearwen Jan 22 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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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