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,
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.
Thanks for your response v-kpoloju-msft.
I was afraid that there was no out of the box 'Drill down' button action available for me to configure a button with.
I had set up my matrix table with bookmarks capturing the expansion of the different heirarchies. However, my users wanted a solution configured where they could control and change the order of the heirarchy of the matrix itself - thats why I had to pivot to using the field parameters to control the heirarchy of the matrix!
Just as a suggestion though, a Drill-Down action would be super super helpful as it can be configured into a button, which would improve the UI/ UX of the reports in the Web as the drill down buttons tend to be hard for users to navigate to.
There is nothing in Power BI that captures the cadence of the user actions on field parameters. You can know which items (columns or measures) are selected but you cannot know in which order. Not for a hierarchy and not for a flat table.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
