Forum Discussion
Super UserHow to Set Up Drill-Through to Different Pages Based on Field Value in Power BI?
Topic resolved by this Guy:
https://www.youtube.com/watch?v=ZeuEaSsJiPY
Best,
Jacek
Super UserDrillthrough 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.
Super UserThanks 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-sgandrathiCommunity Support
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.