Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
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
@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.
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.
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
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |