A published BI Portal view becomes genuinely interactive once three features are wired together correctly: filter widgets, saved variants, and drilldown between connected charts. Skipping any one of them turns an otherwise solid dashboard into a set of static pictures.
Filters and how widgets react to them
- Add a Live Selection Filter (Live mode) or Result Filter (Offline mode) widget, then add fields — text, number, date, dropdown, multi-select, button display, or cascading
- By default, chart/KPI/table widgets on the same data source react to all filters; this can be narrowed per widget to selected filters or no filter when a KPI card should stay fixed regardless of a slicer elsewhere on the page
- A Button widget in data/slicer mode can act as a filter source for every other widget on the page — a common pattern for "pick a scenario" style dashboards
- Toggle automatic run-on-change, or leave manual refresh via the toolbar's Run All when filter changes are expensive against a Live source
Drilldown
Clicking a slice or bar on a chart automatically filters every connected widget by that value — a drilldown badge with field=value tags appears at the top of the page, and the X icon clears it. If no data matches, the widgets show a clear "no data for this selection" state instead of silently going blank.
View Variants
Frequently used filter combinations do not need to be re-entered every time — set the filters, save as a named variant, and later load, delete, or star it as the default. This is the difference between a dashboard a manager tolerates and one they open first thing every morning.
Why it matters
Filters, drilldown, and variants together are what separate a "report" from an actual analysis tool — the same published view serves a dozen different questions depending on who is using it and which slice they saved, without a designer building a dozen separate pages.