Ravindra BagaleCourses & study guides

17. Drill Through

17.3 Drill-through Options

Option (Build visual pane › Drill through) What it does When to use
Cross-report (On/Off) Allows other reports in the same workspace to drill into this page Separate "Operations" and "Store Detail" reports
Keep all filters (On/Off) On: passes all filters from the source (slicers, page filters, the other fields of the clicked point, e.g. Platform = Blinkit). Off: passes only the drill-through field(s) On when the context matters (selected month, platform); Off for a clean store view
Drill through when: Used as category / Summarized (per field) Used as category: drill appears when the field is on an axis/rows. Summarized: drill appears when the field is used as a value (e.g. Count of Store Name) Leave the default Used as category in most cases

What gets passed. With Keep all filters off, the target page receives the drill-through field value (Store Name = Blinkit Kothrud Hub). Filters that were directly applied on the source page (for example a Platform slicer) are not passed. With it on, the date slicer (October 2025), Platform = Blinkit and the clicked point's other fields are also passed. Check the result on the target page in Filters pane › Drill through filter card.

Multiple drill-through fields

Add City and Store Name to the drill-through well. Users can then drill from visuals showing either field. The page is available whenever at least one of the fields (depending on settings) is present in the source point.

Ravindra Bagale's Tip

Friends, remember: with Keep all filters On, the filters can combine with a conflicting filter on the target page and show blank visuals. Decide whether the target page should inherit slicers like Month, and check the Filters pane on the target page when it shows nothing. Keep this in mind!