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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Florim
New Member

Dynamic Hierachy level switching

I'm trying to build a matrix in which the user can arrange the dimensions in the line area as he likes. And that directly in the report. Currently, I have the option of using bookmarks to put a respective dimension to the head, ie on the first level of the hierarchy, but not to arrange the other underlying dimensions. The bookmark has a fixed table.

I have 7 dimensions in the line area, so I can not create a button for each constellation in the report. That would be too many.

 

In the example below, you can see how to solve this example in Qlik. You have the dimension names as buttons and you can drag and drop them as you want.

 

Qlik.png

 

 

Anyone having an idea how to do that in Power BI?

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Florim,

 

As far as I know, there is no elegant way. You may submit an idea.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors