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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
admin_xlsior
Post Prodigy
Post Prodigy

On Matrix visual, can we block/disable the hierarchy button

Hi,

Is there a way to disable or block the buttons for drill up/down, everything except the rightmost button in Matrix visual ?

I mean this ->

admin_xlsior_0-1617591404318.png

I am also interested to disable the expand/collapse button, but only for the 2nd row header and so on, so only the top items have the expand / collapse function.

 

Any trick for this ?

Thanks in advance

1 ACCEPTED SOLUTION

@admin_xlsior  Yes, top values would be repeated with concatenate. If you have an index you could use that to avoid the repetition somehow but that will likely slow down the DAX query.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

3 REPLIES 3
AllisonKennedy
Super User
Super User

@admin_xlsior  What do you mean by right most button? You can turn off the visual header for the matrix to get rid of the buttons at the top of the visual, but this gets rid of all of them. 

 

A workaround for disabling expand/collapse buttons for 2nd row header and below could be to concatenate the values in a DAX measure and use it in Values rather than Rows so that it's not possible to expand/collapse.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Hi,

Yeah, not really rightmost, it is actually say more in my picture, means I'm fine to have the filter info and maximize visual button (2 rightmost). I just want my user to "do not play" with the hierarchy.

 

and yes, Visual header off will make all of it gone, so I guess no options here.

 

For the new measure, it is good idea as well. only I tried to not make many more measures, but then again it's a good idea. But concatenate will make the top items which is the grouping repeated doesn't it ?

 

Thanks

@admin_xlsior  Yes, top values would be repeated with concatenate. If you have an index you could use that to avoid the repetition somehow but that will likely slow down the DAX query.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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