- 14 Mar 2023
- 1 Minute to read
- Updated on 14 Mar 2023
- 1 Minute to read
In this article, we will introduce cross-filtering. Cross-filtering enables you to apply a data element from a chart (e.g., a table row, a slice from a pie chart) and then apply it as a filter across all eligible charts in the dashboard.
In order to use cross-filtering, you need to use an eligible chart:
- All charts built with ECharts
- Area Chart
- Bar Chart
- Graph Chart
- Line Chart
- Mixed Chart
- Pivot Table Chart
- Scatter Plot
- Smooth Line Chart
- Stepped Line Chart
- Table Chart
- World Maps
Cross-filters can be used in any dashboard with eligible charts.
To illustrate the usage of cross-filtering, we will do a walkthrough showing three charts: 1 table chart and 2 pie charts. The data pool is comprised of software developers, with the pie charts asking, "Are you an ethnic minority?" and "What is your gender?" and the table showing the top 15 languages spoken at home.
In the "Are you an ethnic minority?" pie chart, let's hover the cursor over the Yes, an ethnic minority pie slice, and select it.
After doing this, the selected filter—Yes, an ethnic minority—will be applied to the other two charts.
You'll notice in the graphic below that the "Gender" pie chart and the "Top 15 Languages" table have both been updated to reflect the applied filter:
Now, let's add an additional cross filter by selecting Female in the "Gender" pie chart:
...and you can see that both filters—one from each pie chart—are being applied to the table. The table now shows the top 15 languages spoken at home by female ethnic minorities.
This is demonstrated by the small number "2" icon, which conveys the number of filters currently being applied to the chart:
You can check which cross-filters are active in the dashboard filter bar.
In some situations, you may want to prevent dashboard consumers from using cross-filtering.
To disable cross-filtering, click on the Gear icon in the dashboard filter bar, and uncheck the "Enable cross-filtering" box.