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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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