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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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