# The List View Threshold

SharePoint list views have a limit on the number of items which can be matched by the filter. In SharePoint Online, this is 5000. In 'On Premise' environments it's configurable, but 5000 by default.

Charts can only be rendered based on a maximum of this limit of items. If your filter or view exceeds this limit, you'll receive the following error message:

> Failed to render the series. The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Try selecting a view which returns less than 5000 items.

The key to overcoming this limit is to decide how to split your data appropriately - it'll have the positive side effect of making it more easily understandable for the viewer.

For example, instead of rendering a chart to display ***Sales by Region***, you could display ***Sales by Region - Last Quarter*** or ***Sales by Region - this year*****.**

Technical options are outlined below.

{% hint style="warning" %}
Note: any fields you intend to filter on should be Indexed.
{% endhint %}

### Add a secondary grouping

You can split your data into multiple data-series by selecting the **secondary grouping**:

![Add a secondary grouping field](/files/-MAI4SplXTzRQL26jbdn)

This relies on each individual data series also coming in under the 5000 item limit. it can provide for more informational charts.

### Add a filter

A filter can be added under Filtering > Field to filter:

![Adding a filter](/files/-MAI8si5_VXETrZQIPHr)

### Create a custom view with a filter

You can filter on any view. To do this, select a view under Filtering > View:

![](/files/-MAI522aU8vSObKxGbU1)

You can configure a custom view and it'll show up here. Your view should be created such that it matches less than 5000 items. 


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.listburst.app/sharepoint-tips/the-list-view-threshold.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.