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 al...
Need Help
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.