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

[admin_xlsior]

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 ->

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

[AllisonKennedy]

@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.

[admin_xlsior]

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

[AllisonKennedy · 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.