How to Set Up Drill-Through to Different Pages Based on Field Value in Power BI?

[jaryszek]

Hi everyone,

I’m building a Power BI report with an amortized cost fact table that includes a column for PricingModel (with values like “OnDemand” and “SavingsPlan”) as well as cost columns. I’ve also got a standard date dimension.

Dim_Date: 

I have created a simple main page (see screenshot) that summarizes the cost data by Pricing Model.
In addition, I set up two drill-through pages: one for “OnDemand” and one for “SavingsPlan.”

Is it possible in Power BI to set up drill-through so that when a user right-clicks a value (e.g., “OnDemand” or “SavingsPlan”) on the main visual, they are automatically routed to the correct drill-through page—based on the value selected?

Or, does Power BI only show a menu of available drill-through pages for the user to pick from manually?
Is there any way to make this navigation dynamic, so the page is chosen automatically according to the selected value?

---

What I’ve done so far:

Created the tables and visuals as shown.

Built two separate drill-through pages, each with a drill-through filter on PricingModel.

When I right-click a value in my visual, Power BI shows both drill-through pages as options.

Thank you,
Jacek

[jaryszek · Accepted solution]

Topic resolved by this Guy:

https://www.youtube.com/watch?v=ZeuEaSsJiPY 

Best,
Jacek

[v-sgandrathi]

Hi @jaryszek,

In Power BI, you cannot currently make drill-through navigation fully automatic based on a field value. Power BI always displays a list of all matching drill-through pages when multiple are available, and the user must choose one manually. However, there are workarounds to simulate or enhance this behavior.

1. Use Buttons + Bookmarks for Conditional Navigation.

2. Use One Drill-Through Page with Visual-Level Filters.

The right-click drill-through menu is by design in Power BI, and currently does not support conditional navigation to one page automatically.

Users must choose from the list if multiple drill-through pages match.

Need	Power BI Supports?	Workaround
Auto-navigate to specific drill page	No	Use button navigation + bookmarks
Filtered drill-through view	Yes	Use a single page with filters

Hope this helps you, Thank you.

[jaryszek]

Up, anyone can propose something?

Best,
Jacek

[jaryszek]

Anyone can help?

Best,
Jacek

[lbendlin]

Drillthrough is based on a column, not on a value. Having said that - the value(s) of the drillthrough column is/are applied as an extra filter in the target page.  So you can structure that page accordingly.

If you set up multiple drillthrough target pages then the report user can choose between them.

[jaryszek]

Thanks but what if i have different charts on different page. 

Can I workaround drillthrough with chosen value and move to specific/dedicated page for value?
How to make this?

Best,
Jacek

[lbendlin]

Let the report user decide.

[v-sgandrathi]

Hi @jaryszek,

To automatically navigate to different report pages based on the value selected in a field (like PricingModel with values such as "OnDemand" and "SavingsPlan"), without relying on Power BI's manual drill-through menu. For this I am including .pbix file for your better understanding, please have a look into it.

So when a user chooses "OnDemand" or "SavingsPlan" in the slicer, the button is enabled.

Clicking the button takes the user directly to the relevant detail page, without displaying a list of drill-through options.This approach offers a simpler and more guided experience, which is helpful when different visuals appear on separate pages.

Hope this will help you resolve your issue, if you need any further assistance, feel free to reach out.

Thank you.

[jaryszek]

Hi,

thank you,
something is not working. 

[v-sgandrathi]

Hi @jaryszek,

Thank you for microsoft Fabric Community Forum.

I’m sharing the working .pbix file below so you can explore the setup and DAX logic more clearly. Please feel free to open it and review how the relationships and measures are configured:

I hope this helps resolve your issue. If you have any questions or need further clarification, I’m happy to help.

Thank you.

[v-sgandrathi]

Hi @jaryszek,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

Thank you.

[jaryszek]

Have no idea how this would work?

you replaced the file with "On Demand" and "Savings" with some not working one....

[v-sgandrathi]

Hi @jaryszek,

As Power BI doesn't support automatic routing to a specific drill-through page based on a selected value, I implemented an alternative approach using buttons with navigation logic and bookmarks.
Instead of relying on the default right-click drill-through, I created separate navigation buttons linked to individual bookmarks for each pricing model (OnDemand and SavingsPlan).
These buttons are dynamically controlled using slicer selections and DAX-based visibility rules, allowing users to navigate to the appropriate page based on their selection.
This method provides a smooth and user-friendly experience, especially when drill-through limitations apply.
The implementation I shared in the previous .pbix file demonstrates this alternative approach in action.

If you want this feature to be considered, I suggest submitting it to the Power BI Ideas forum. This is the most effective way to bring it to the attention of the Microsoft product team.
Fabric Ideas - Microsoft Fabric Community

Thank  you.

[jaryszek]

sorry but your example like you see on my screen is not working. 

https://community.fabric.microsoft.com/t5/Developer/How-to-Set-Up-Drill-Through-to-Different-Pages-B...

i show exactly what is not workin in this screen. You pasted some entirely different model witohut PricingModel field...

Please do not close the topic. 
Waiting for other users for help.
Best,
Jacek