Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting values from Excel into the slicer search/paste box.
Today, pasted values usually match only the first (top) hierarchy level. This is a problem when users need to paste at a deeper level. For example, with a Product RCN > SKU Key slicer, users may want to paste a list of SKU values, but the slicer tries to match against RCN instead. Sometimes users paste RNs; sometimes they paste SKUs. The current behavior forces workarounds such as removing hierarchy, adding extra flat slicers, using the Filter pane, or building custom DAX logic.
Requested enhancement:
Add an option to control which hierarchy level pasted values should match.
Suggested options:
- A slicer setting: "Paste match level" (Level 1, Level 2, Deepest level, etc.)
- A user-facing control before paste: "Paste as: RCN" or "Paste as: SKU"
- Optional auto-detect: match pasted values across hierarchy levels and select the best match
Example:
Slicer hierarchy: Product RCN > SKU Key
- User pastes SKU-001, SKU-002, SKU-003 → slicer should select those SKUs
- User pastes RCN-100, RCN-200 → slicer should select all SKUs under those RCNs
- Ideally, users can choose the target level before pasting
Benefits:
- Faster bulk filtering without workarounds
- Keep hierarchy for browsing while supporting paste at the correct level
- Less report complexity (fewer duplicate slicers and custom measures)
- Better self-service for business users
Why this matters:
Current workarounds reduce usability and increase maintenance. A native "paste target level" option would make hierarchical slicers work for both exploration and Excel-driven bulk filtering.
