In addition to the standard dashboard filter controls, Omni offers two ways to make filtering more interactive:Documentation Index
Fetch the complete documentation index at: https://docs.omni.co/llms.txt
Use this file to discover all available pages before exploring further.
- Cross-filtering — viewers click chart elements to filter the rest of the dashboard
- Faceted filters — one filter narrows the options shown in another, for example a state filter narrowing a city filter to cities in that state
Requirements
Creating and modifying filters requires Editor, Manager, or Owner permissions on the document.Cross-filtering
Cross-filtering lets viewers filter a dashboard by clicking elements in a chart. When a viewer clicks a data point, bar, or other element, they get the option to create a filter that applies across all compatible tiles. Cross-filters apply to any tile with a joinable relationship to the filtered field through the semantic model. When a cross-filter is active, tiles that can’t be filtered are dimmed and display a badge explaining why.Supported visualization types
Cross-filtering works with:- Vega-Lite charts (bar, line, area, scatter, heatmap)
- Pie and donut charts
- Maps (choropleth and point)
- Data tables
- Sankey
Enabling cross-filtering
Cross-filtering is off by default. Enable it in the dashboard’s settings.Creating a cross-filter
There are several ways to create a cross-filter from a chart:- Click-to-filter — click any chart element to filter the dashboard by that value
- Brush selection — on charts with a continuous axis (time series or numeric), click and drag to select a range. This creates a range filter on all compatible tiles.
- Multi-select — after creating a cross-filter on a discrete field,
Cmd + Click(Mac) orCtrl + Click(Windows) to add more values
Removing a cross-filter
When a cross-filter is active, a chip appears below the dashboard filters. Click the on the chip to remove it.Highlighting and dimming
Clicking an active cross-filter chip highlights the source tile (where the cross-filter originated) and dims tiles that can’t be filtered by that field. This makes it easier to see which tiles each cross-filter is affecting.Limitations
- Cross-filters don’t apply to null values
- Custom SQL queries don’t automatically support cross-filtering unless they use dynamic filtering
- Linked tiles — tiles sourced from a separate workbook tab have their own query and can’t receive cross-filters
- Raw SQL tiles — SQL-mode tiles can only be cross-filtered if they include a templated filter (
{{# fieldName }}) for the relevant field
Faceted filters
Faceted filters automatically link two filters so that one narrows the values of another. For example, astate filter limits the city filter’s options to only cities in the selected state. Faceted filters also work alongside access filters.
Enabling faceted filters
Faceted filters are off by default. Enable them in the dashboard’s settings.Next steps
- Working with dashboard filters — create filters, set defaults, and connect them to tiles
- Filter display options — choose how filters are displayed to viewers
- Dashboard settings — toggle cross-filtering, faceted filters, and other dashboard behaviors