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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.