Forum Discussion
Resolver IDrill through with selection from multiple sources
Hi
I have a report that I'm trying to help with. They want to have a landing page with 6 charts and 3 slicers. They want users to be able to select a combination of the slicer items and items from the charts (one items from each chart, so might be chart 1 open, closed, overdue for instance). Once their selection has been made they want to be able to drill through to a table view of this selected data.
I have tried using a drill through button - which appears to disable once a selection from more than one chart is made. I can do this by right clicking on one selection and using the drill through options there, but this isn't as clean from a UX point of from.
Has anyone made this kind of thing work, or used a workaround?
7 Replies
- krishnakanth240
Super User
Hi Back2Basics
Drill-through supports the context from a single visual. When users select multiple visuals, drill-through button gets disabled.
From my understanding, you can create a detail page and not to use drill-through fields. Pass the context using existing slicers and cross-filtering, then add a button with page navigation to navigate to detail page.
- cengizhanarslan
Instead of drillthrough, use a normal page navigation button and let the filters carry over.
How it works:
All slicer selections and chart selections are already part of the filter context
When you navigate to another page, that context is preserved
The table page simply shows “whatever is currently filtered”
Steps:
Create a Details page with your table visual
Do not add drillthrough fields
Add a button on the landing page:
Action = Page navigation
Destination = Details page
Users:
Select slicers
Select one value in each chart
Click the button → table shows the exact combination
This works with multiple slicers + multiple chart selections.
Use drillthrough only when:
The interaction is driven by one primary dimension (e.g. Customer, Order, Case ID)
You want right-click, context-specific navigation
Back2BasicsThanks for the suggestion. I have tried this but can't get it to work.
The data on the details page is only filtered by the slicers, not by the selection in the graphs and charts.
v-veshwara-msftCommunity Support
Hi Back2Basics ,
Thanks for reaching out to Microsoft Fabric Community.Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.- Back2Basics
unfortunately the responses have not resolved the issue. I don't think it is possible to filter across mutliple pages in this way
- v-veshwara-msft
Hi Back2Basics ,
Thanks for confirming.
This is expected behavior in Power BI. Selections made directly in visuals such as clicking bars or data points are page scoped and do not persist when navigating to another page. With page navigation, only slicers and page or report level filters are carried over, which is why the details page is filtered by slicers only.
Drill through has a similar limitation. It supports context from a single visual and is disabled once multiple visuals are selected.
Because of these design limitations, filtering a details page based on multiple chart selections from another page is not supported today. To achieve similar behavior, the detailed table would need to stay on the same page, or the filtering would need to be driven entirely through slicers.
You can find similar explanations discussed here for reference:
Solved: Drill Through Limitations - Microsoft Fabric Community
Solved: Drill Through and Page Navigation with a Single Bu... - Microsoft Fabric Community
You may also consider submitting this as an idea in the Ideas forum so it can be reviewed by the product team.
Hope this helps. Please reach out for further assistance.
Thank you.
