Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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?




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors