---
metadata:
  - name: generator
    content: Diplodoc Platform v5.63.0
alternate:
  - en/dashboard/chart-chart-filtration
  - ru/dashboard/chart-chart-filtration
  - href: en/dashboard/chart-chart-filtration.md
    type: text/markdown
    title: Markdown version
csp:
  - script-src:
      - https://mc.yandex.ru
    img-src:
      - https://mc.yandex.ru
    connect-src:
      - https://mc.yandex.ru
      - wss://mc.yandex.ru
    child-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-ancestors:
      - 'blob:'
      - https://mc.yandex.ru
canonical: en/dashboard/chart-chart-filtration.html
title: Cross-chart filtering in DataLens On-premises
description: >-
  This article describes how to set up chart filtering by other charts in
  DataLens On-premises.
vcsPath: en/dashboard/chart-chart-filtration.md
---

# Cross-chart filtering in DataLens On-premises

DataLens allows you to set up [filtering of charts by other charts](../operations/dashboard/add-filtration.md) on the dashboard. A chart with filtering configured can thus be used as a selector for other charts.

To apply filtering, click an individual item in the filtering chart, e.g., a point on a graph, a column, or a pie chart segment. The linked charts will then be filtered by the selected dimensions.

You can reset chart filtering in two ways:

* Click the selected item once again.
* Click <!-- diplodoc:svg ![image](../_assets/datalens/clear-filters.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" aria-hidden="true" class="yc-icon widget-header__icon-filter-clear"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 16"><path fill="currentColor" fill-rule="evenodd" d="M10.055 7.602 8.31 10.16a.354.354 0 0 0-.061.2v2.39c0 1.5-1.25 2.5-2.75 2.5s-1.75-1-1.75-1v-3.89a.354.354 0 0 0-.061-.2L.562 5.577A3.242 3.242 0 0 1 0 3.75c0-2 2.686-3 6-3 .461 0 .91.02 1.341.059a2.24 2.24 0 0 0-.323 1.478A13.777 13.777 0 0 0 6 2.25c-1.538 0-2.799.237-3.615.613-.814.375-.885.713-.885.887 0 .175.071.513.885.888.816.376 2.077.612 3.615.612.355 0 .695-.012 1.018-.036a2.24 2.24 0 0 0 .323 1.478c-.43.04-.88.058-1.341.058-1.114 0-2.158-.113-3.052-.339l1.98 2.904c.21.308.322.672.322 1.045v3.37c.06.011.141.02.25.02.422 0 .749-.14.95-.316a.86.86 0 0 0 .3-.683V10.36c0-.373.112-.737.322-1.045l1.214-1.78a2.241 2.241 0 0 0 1.77.067Zm-4.936 6.085c-.01-.006-.013-.01-.013-.01s.005.002.013.01Z" clip-rule="evenodd"/><path fill="currentColor" fill-rule="evenodd" d="M9.278.97a.75.75 0 0 0-1.06 1.06l1.72 1.72-1.72 1.72a.75.75 0 0 0 1.06 1.062L11 4.812l1.72 1.72a.75.75 0 1 0 1.06-1.062l-1.72-1.72 1.72-1.721A.75.75 0 0 0 12.72.97l-1.721 1.72L9.279.97Z" clip-rule="evenodd"/></svg></svg> in the top-right corner of the chart.

You can choose multiple filtering values on the same chart:

1. Click the first dimension value for filtering.
1. Hold down the `Ctrl` (`Cmd`) key on your keyboard and select the other values.

Filtering is available for the following types of charts created using the [wizard](../concepts/chart/dataset-based-charts.md):

* [Line chart](../visualization-ref/line-chart.md)
* [Column chart](../visualization-ref/column-chart.md)
* [Scatter chart](../visualization-ref/scatter-chart.md)
* [Pie chart](../visualization-ref/pie-chart.md)
* [Table](../visualization-ref/table-chart.md)
* [Pivot table](../visualization-ref/pivot-table-chart.md)
* [Combined chart](../visualization-ref/combined-chart.md)


You can check how charts are filtered by charts on the [demo dashboard](https://datalens.yandex/9fms9uae7ip02?tab=LoG).



## Recommendations and limitations {#using}

When using chart filtering, keep in mind the following:

* Charts created in the wizard are filtered using all dataset dimensions except for fields of the [tree of strings](../dataset/data-types.md#tree-hierarchy) type, [hierarchies](../operations/chart/add-hierarchy.md), and fields containing [markup language](../function-ref/markup-functions.md). Fields [created at the chart level](../concepts/aggregation-tutorial.md#add-measure-in-chart) do not participate in filtering.
* Clicking a cell in the **Table** chart applies filtering by all the dimensions of the selected row.
* In **Pivot table** charts, filtering charts by other charts only works for indicators.
* The state of filtered charts is saved in the dashboard's `state` parameter. You can share a link to such a dashboard.