Forum Discussion
Matrix Drill Down Button
Hi ssrinath,
Thank you for posting the query in Microsoft Fabric Community Forum. Also thanks to rajendraongole1, for his inputs on this thread. here I provided workaround that might be resovle the issue more quickly.
I understand how important it is to make the drill-down experience smoother for your users, especially when working with dynamic hierarchies using field parameters.Power BI does not offer a built-in way to trigger drill-down automatically via a button when using field parameters. Each time the hierarchy changes through the slicer, the matrix visual resets its drill state, which unfortunately cannot be controlled programmatically right now.
As a workaround, one option is to set up multiple matrix visuals at different drill levels and use bookmarks or buttons to switch between them. Another approach could be to use tooltips or visual indicators to guide users toward the drill-down icons just to make the experience more intuitive.
Kindly refer to the below mentioned documents for more information:
Use parameters to visualize variables - Power BI | Microsoft Learn
Create report bookmarks in Power BI - Power BI | Microsoft Learn
Drill mode in the Power BI service - Power BI | Microsoft Learn
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi ssrinath - You'll have to manually drill down the matrix to the lowest level and create a bookmark while it's fully expanded. Ensure no visuals are selected when creating the bookmark.
Go to the Insert ribbon → Buttons → Blank (or choose a suitable icon).Set its Action type to Bookmark, and assign it to Bookmark B.In the Bookmarks pane, right-click the bookmark → uncheck all options except "Data" and "Visual display".Make sure "Current Page" is selected too if the matrix is on that page.
Make sure the feature is enabled in Options → Preview Features
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-drill
https://community.fabric.microsoft.com/t5/Desktop/Using-Drill-down-with-parameters/td-p/4131515
Hope this helps.
Thanks so much for your response rajendraongole1 .
I tried this, and I think it would work for most cases.
But for me, this wont work unfortunetly. Because I am using field parameters to control the heirarchy of the Matrix, the Drill-down to the lowest level can constantly change based on my selection of the slicer. So essentially, the level of the heirarchies selected can range to 1 to the max, which is 6.
Additionally, the Current Page option for the bookmark doesn't preserve other slicer selections and captures the state of the full page, not the selected matrix only.
In any case, I really appreciate your suggestion!
