Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowFabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now
Summary:
Power BI currently supports drilldowns (e.g., hierarchy-based navigation like Year → Quarter → Month) and drill-through pages based on filter context. However, there's no native support for "Drill Across" — a powerful feature in one of the well know BI enterprise tool that allows users to drill between unrelated attributes or columns, even if they aren’t part of the same hierarchy or table.
Problem Statement:
In many enterprise use cases, business users need to explore data laterally across unrelated dimensions. For example, from a "Product" summary, a user may want to drill into "Customer Region" or "Order Status" — attributes from entirely different domains or tables.
This kind of exploration is not possible today in Power BI unless we create multiple drill-through pages with predefined relationships or use complex workarounds.
Feature Request:
Introduce native "Drill Across" capability that allows users to define custom drill maps or navigation paths between unrelated fields/tables — without relying on traditional hierarchy or model relationships. Similar to how MSTR allows:
i) Drill Up / Down (within a hierarchy)
ii) Drill Across (across unrelated columns/attributes)
Benefits:
1. More flexible data exploration
2. Better user-driven analysis
3. Reduces the need for multiple drill-through pages
4. Aligns Power BI closer with enterprise-level BI features.
Example Use Case:
From a "Sales by Product" visual, a user could drill into "Customer Demographics" or "Shipping Status" — without needing to predefine all relationships or drill-through pages.
Current Workarounds (Not Ideal):
i) Creating multiple drill-through pages
ii) Using bookmarks with filters
iii) Modeling artificial relationships
Conclusion:
"Drill Across" would significantly enhance Power BI’s self-service capabilities and bring it closer to feature parity with other enterprise BI tools. Please consider adding this to the roadmap.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.