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 UserHi,
thank you,
something is not working.
Community SupportHi 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.