Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Always expand down all levels in hierarchy when using field parameters as x-axis

I understand that buttons and bookmarks can be used to show an "expanded down one level" view to the users (Solved: Expand all down one Level in hierarchy - Always vi... - Microsoft Fabric Community) when using x-axis data fields that are fixed and the view is fixed. However, I am building a self-service report and have used field parameters as an x-axis data field. And I have added the same field parameter as a slicer so that the user can select the attribute they want to see in the x-axis. 

Additionally, I have provided the ability to multi-select from the slicer. This means every time the user selects multiple fields for the x-axis, they will have to either try and find the disappearing icon rushi_0-1687225222884.png OR go through the ordeal of right-clicking the visual and finding the right option to expand down one level. To make matters worse, if more than 2 fields are selected, they would have to do the same for those number of times to expand down all levels in the hierarchy.


Is there no way I can have the visual expand down all levels in the hierarchy by default so that when the users select multiple fields for the x-axis, they can see the intended visual?



New Member

Hi Rushi, 


I am dealing with the same problem, did you ever manage to find a solution?

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors