Dynamic show/hide column(head+values) in matrix preview after drilling down

[Anonymous]

Hi, I have a problem that has plagued me for a day.

I am using Matrix Preview to show many calculated measures(from Bud to Rem%) for each GL Account. Please see attached screenshot 1.

The Drill-down fuction has been turned on. When I click on a specific GL Account, it will show the same measures by different date. It works good.

The question is how to show other column values after drilling down. The ideal looks like this:

Then if I drill up to the original matrix, the new three columns will disappear.

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Current new matrix visual not support to add other columns after drill down.

In addition, it also not support to control the columns to display after drop down.

Regards,

Xiaoxin Sheng