Master Filtering for the Grid Item in the WinForms
- 2 minutes to read
The BI Dashboard allows you to use a Grid dashboard item as a filter for other dashboard items (Master Filter). To learn more, see the Master Filtering topic, which describes filtering concepts common to all dashboard items.
Configure Master Filters in the Designer
The Grid dashboard item supports filtering by rows.
When Master Filtering is enabled, a user can click a grid row (or multiple rows by holding down the CTRL key) to make other dashboard items only display data related to the selected record(s).
Note
You can use Master Filter or build criteria in the Filter Editor to filter total values. The Grid column’s drop-down filter menu does not affect grid totals as they are calculated by the dashboard data engine.
To learn how to enable Master Filtering in the Designer, see the Master Filtering topic.
To reset filtering, use the Clear Master Filter (
) button in the Grid’s caption area, or the Clear Master Filter command in the context menu.
If a column sequence starts with several Measure columns followed by Dimension columns, master filtering uses these dimensions. However, columns that follow the Dimension(s) - Measure(s) combination are excluded from master filtering.
In the picture above, the columns CategoryName and ProductName are included in master filter, while the SalesPerson column and subsequent columns are not.
Member Table
- DashboardItemInteractivityOptions.MasterFilterMode
- Gets or sets the selection mode of the master filter item.
- GridDashboardItem.InteractivityOptions
- Provides access to interactivity options, such as Master Filtering and drill-down settings.