Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

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

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

Need Help

14 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    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's avatar
      jaryszek
      Icon for Super User rankSuper User
      1 year ago

      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

  • jaryszek's avatar
    jaryszek
    Icon for Super User rankSuper User
    1 year ago

    Up, anyone can propose something?

    Best,
    Jacek

  • v-sgandrathi's avatar
    v-sgandrathi
    Icon for Community Support rankCommunity Support
    1 year ago

    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.