Power BI Drill-through – Show Different Tables on the Same Drill-through Page Using a Single Button

[Nikhil_AZ]

I have a Power BI report with a bar chart on the main page and a drill-through button that navigates to a detailed page.

The requirement is:

• From the same bar chart

• Using one single drill-through button

• Navigate to one drill-through (detail) page

• But display different table visuals on the drill-through page depending on which bar is selected

Specifically:

• For some bars, one table should be displayed on the drill-through page

• For other bars, a different table (from a different fact table) should be displayed

• The tables have different schemas and come from different source tables

• The drill-through field comes from a common dimension table related to both fact tables

Constraints / challenges:

• I do not want multiple drill-through pages

• I do not want multiple drill-through buttons

• The table that is not relevant should be completely hidden (including column headers)

• This should happen automatically after drill-through, with no additional user interaction on the drill-through page

What I’ve tried so far:

• Using measures with SELECTEDVALUE() to control visual-level filters

• Hiding visuals using filters and transparent backgrounds

• Using cards/shapes to cover inactive tables

• Using bookmarks and selection pane to toggle visibility

However:

• Measures cannot truly hide table visuals

• Table column headers cannot be conditionally hidden

• Bookmarks cannot be triggered automatically based on drill-through context

Because of these limitations, I’m unable to get a single drill-through page to automatically switch between two different table visuals based on the selected bar.

---

Question to the community

Is there any supported or recommended way in Power BI to:

• Use one drill-through button

• Navigate to one drill-through page

• And automatically display different table visuals based on the selected category in the source visual?

Or is this a known limitation in Power BI that requires:

• Separate drill-through pages, or

• A single combined table (UNION), or

• User interaction (bookmarks/buttons) on the drill-through page?

Any guidance or confirmation would be appreciated.

[v-tejrama]

Hi @Nikhil_AZ ,
Thanks for reaching out to Community Forum.

What you're trying to achieve is a valid and common reporting requirement, but it runs into a limitation of how Power BI handles visuals and drill-through. Power BI cannot dynamically show or hide entire table visuals based on drill-through context. Measures such as SELECTEDVALUE() can control which rows appear, but they cannot stop a table from rendering, and column headers will always remain visible even when there is no data. Bookmarks also can't solve this, because they are static and cannot be triggered automatically based on the value passed through drill through.

Because of these constraints, there is currently no supported way to use a single drill through button to navigate to one drill-through page and automatically switch between two different table visuals depending on which bar was selected. This behavior is a known product limitation rather than a configuration or modeling mistake.

In practice, the supported approaches are to combine both fact tables into a single detail table (for example using UNION) and use one table visual, or to create separate drill through pages for each scenario. Any solution that relies on auto toggling visuals without user interaction is not supported in Power BI today.

Thank you.

[Nikhil_AZ]

hi @v-tejrama 
Thanks for your reply.

Even though I combine those tables and make a UNION of both the tables, in the table visual I'll need to all the columns which are required.
And let's say if I drill through for Bar A, I'll defintely see the required data at the detailed page however I'll also see other columns as blank (which are coming from another fact table).
Can we escape this if I consider UNION as a solution?

[v-tejrama]

Hi @Nikhil_AZ ,

I appreciate your objective, and your requirement is entirely reasonable. However, Power BI currently does not support this functionality. The main limitation is that drill through in Power BI only transfers filter context to the target page; it does not control the rendering of visuals on that page. When a drill through page loads, all visuals are rendered immediately, and there is no supported method to show or hide an entire table visual or its column headers based on the drill through value. While measures like SELECTEDVALUE can influence the data displayed within a visual, they cannot determine whether the visual appears. Bookmarks are also not a solution in this case, as they are static and cannot be triggered by drill through context only by direct user interaction. As a result, you cannot use a single drill through button to navigate to one page and have Power BI automatically display different table visuals without user input. The current supported approaches include combining data into a single detail table, creating separate drill through pages for each scenario, or allowing some user interaction on the drill through page. This is a limitation of the platform, not your approach, and your understanding of these constraints is accurate.

Thank you.

[v-tejrama]

Hi @Nikhil_AZ ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[Nikhil_AZ]

hi @v-tejrama ,

To elaborate on the scenario: I have a single bar chart configured with multiple drill-through target pages. Depending on the selected bar (affiliation change reason), only specific drill-through pages are logically applicable. However, when a user right-clicks on any bar, Power BI displays all configured drill-through pages, including those that are not contextually relevant for that data point.

From a UX and data-governance standpoint, this behavior can be misleading, as it exposes drill-through options that should ideally be conditionally available based on the selected category.

Could you please advise on the recommended or supported approach to conditionally control drill-through visibility, or any Microsoft-endorsed design patterns to handle this limitation?
PBIX is attached here, you can take a look to understand this.

[v-tejrama]

Hi @Nikhil_AZ ,

Thank you for the update. Although the PBIX file was not attached, I have reviewed your description and can confirm that the drill through behavior you are experiencing is standard in Power BI. The visibility of drill through pages in the right-click menu is determined by the presence of the drill through field in the visual context, rather than by specific categories or data points. As a result, Power BI displays all drill through pages associated with that field, regardless of their relevance to the selected bar.

Currently, there is no supported method to conditionally display or restrict drill through pages based on the selected value. This behavior cannot be modified using DAX, measures, filters, relationships, or bookmarks, and Power BI does not check whether a target page contains data before showing it. Therefore, submitting a PBIX file would not change this outcome.

To address this from a design standpoint, you may consider consolidating drill through logic, refining the scope and naming of drill through pages, or implementing navigation buttons where access can be controlled with measures. This is a platform-wide limitation and is not specific to your report model.

Thank you,

Tejaswi.

[Nikhil_AZ]

hi @v-tejrama ,
The PBIX was attached in a separted comment. You can access it here 

As you confirmed, there is no supported way to achieve this directly. I am therefore considering implementing it using a different approach.

My idea is to add a “Deep Dive” button at the top-right corner of the bar chart. When the user clicks this button, a shape on the right side of the canvas will overlay the existing visuals (these visuals are not shown in the attached PBIX since it is only a sample; they do exist in my actual file).

After that, when the user clicks a specific bar in the chart, the right side of the canvas should display the corresponding data in a table.

This is the general approach I am considering. I’m open to suggestions if there is a similar or better way to implement this.

Thanks in advance.

[v-tejrama]

Hi again @Nikhil_AZ ,

Given the current limitations in Power BI regarding drill through and visual visibility, your Deep Dive button idea seems to be the most practical solution. Since visuals cannot automatically switch or show/hide depending on which bar is clicked, using a single table visual driven by Field Parameters and a manual Deep Dive button with bookmarks to toggle the overlay panel is a clean and supported approach.

Drill through can still pass the selected context, such as the category, and you can use that context to determine which parameterized columns are displayed in the table. This helps avoid having multiple visuals or empty columns and keeps the experience intuitive, supported, and scalable without relying on unsupported techniques.

Thank you.

[Nikhil_AZ]

Thanks @v-tejrama 

Could you please demonstrate this approach using the sample PBIX file that I shared earlier? I’m having difficulty understanding which field parameters you’re suggesting I create.

Also, the tables that need to be displayed do not share the same columns. Because of that, I believe using a field parameter would result in irrelevant columns appearing as blank for certain bars. 

For additional context about my requirement and the sample file I shared:

• The report contains three pages.

• Page 1 is the main page with the bar chart.

• Page 2 contains a table that is relevant only to the ADDR CHNG bar, and the table on this page should be shown when the user hovers over or clicks the ADDR CHNG bar.

• Page 3 contains a table relevant to three bars: REL T/S, CHILD T/S, and PARENT T/S. When one of these bars is hovered over or clicked, the table on this page should be filtered to show data for the selected bar.

• For all other bars, no table should be shown (blank state).

Could you please clarify how field parameters would work in this scenario, or show it directly in the sample file?

Thanks in advance.

[v-tejrama]

Hello again @Nikhil_AZ ,

I am currently unable to download the PBIX file. Could you please share the PBIX again, ensuring that any sensitive data is removed.

Thank you.

[Nikhil_AZ]

hi @v-tejrama 
Do you see any error while downloading it? 
PBIX file 

[v-tejrama]

Hi @Nikhil_AZ ,
I tested the attached PBIX and confirmed that drill through is working as designed. Power BI does not support conditional drill through routing or dynamically switching tables/pages based on the selected bar, so an empty drill-through page is expected when no matching data exists. The current approach of using clearly named, separate drill through pages already addresses the requirement, and introducing an additional Deep Dive button or overlay would not add functional value, only a different navigation style. Any further changes would be limited to UX improvements such as adding a - No details available for this selection message, renaming pages clearly, or hiding pages from navigation.

[Nikhil_AZ]

hi @v-tejrama 

And we were also considering using Field parameters to dynamically switch the column.
Can you please give me your thought on that?

[v-tejrama]

Hi @Nikhil_AZ ,

Thank you for your follow-up. I would like to clarify that field parameters are not suitable for this scenario. While they allow users to switch columns or measures within the same visual, all fields must be from a single table structure. Field parameters cannot dynamically switch between tables with different schemas, control which visuals are displayed, or determine which drill-through page is accessed.

As such, they do not address the core requirement. Based on testing the attached PBIX, the current setup with distinct, clearly labeled drill-through pages functions as intended and aligns with Power BI’s supported capabilities. The behavior of an empty drill-through page when no matching data exists is expected. Any additional changes would focus on enhancing user experience, such as improving page names, adding messages for no available details, or hiding pages from navigation. This approach maintains a clean model, avoids unsupported solutions, and ensures reliability for end users.

Thank you.

[Nikhil_AZ]

Thanks @v-tejrama 

I am now considering appending both the tables in one and then use a singl table visual.

Will field parameter work here as expected, and show the relevant columns for the selected bar?
If yes, can you please show me how.

[v-tejrama · Accepted solution]

Hi @Nikhil_AZ ,

I have reproduced this from my end based on your suggestion.

As mentioned, I appended both the tables into a single table and used one table visual on the drill through page. I then used field parameters along with drill through context to switch the relevant columns automatically based on the selected bar.

So yes, field parameters do work for this scenario to control which fields return data when drilling through from different categories.

However, one limitation I observed (and confirmed) is that Power BI does not conditionally hide column headers in a table visual. 

Please find the Below attached .PBIX file demonstrating this end to end behavior.

[Nikhil_AZ]

hi @v-tejrama 
Thanks for your consistent response on this thread.
I had already implemented this and yes I was facing the same problem of visibility of column headers and was wondering if we have any workaround, but seems like we don't have. 😞

[v-tejrama]

Hi @Nikhil_AZ ,

This feature could be a valuable addition to the Power BI Ideas forum, as it would significantly improve drill-through scenarios.

You may want to submit your detailed feedback through Microsoft’s official channels, such as Microsoft Fabric Ideas, since these are regularly reviewed by the product teams and can influence future updates.

Fabric Ideas - Microsoft Fabric Community

Thank you,
Tejaswi.

[cengizhanarslan]

Power BI cannot “switch” a table visual’s schema dynamically, and you also can’t conditionally hide table headers. So with two different fact tables / different columns, there is no fully automatic, supported way to have one drillthrough page show Table A for some bars and Table B for others with zero user interaction.

Instead create one drillthrough page per schema and route users accordingly (you can still keep one “Details” button on the main page, but the destination must be fixed, so users typically use right-click drillthrough or separate buttons).

[danextian]

You are honestly asking for too much in a single without even providing a pbix that anyone could work on.