How to lock the "Drill On" to Columns in a Matrix object with two Rows and two Columns?

[mebg123]

Hello experts,

I have two matrix objects that are hidden/unhidden by using two bookmark buttons. These matrixes have two columns and two rows each, so the Drill On option appears so I can choose between drilling by columns or by rows. The default option is "Drill on" by Rows.

I need to use by default the "drill on" by columns (as shown in the screenshot). But everytime i change pages or click into the bookmark buttons, the value resets into Rows. How do I change this so everytime I'm on the table it stays in Drill on Columns?

[MFelix · Accepted solution]

Hi @mebg123 ,

This option cannot be defined in Power BI, the default is the drill down on rows, you need to do it manually.

[mebg123]

Is there a reason? this makes the UX more unfriendly

[MFelix]

Don't know, maybe you can  check if there is an idea on the ideas part of the forum.