navigating through column level

[RashmitaR]

Hi I have a model which consits of a measure as diret_cost.

where,

direct_cost=[sal]+[travel_cost]+[other_cost]. sal,travel_cost,other_cost are columns in my model.I want a matrix where in i have direct_cost in my values but when I click on the direct_cost column of the matrix , it must show me the corresponding values for sal,travel_cost and other_cost in saperate columns.

Can some one help me with the same .

[v-sihou-msft · Accepted solution]

@RashmitaR

Currently the newest matrix preview can only drilldown on hierarchy you put on row group. It's not possbile to drilldown measures Values box. You have to split into three measures into matrix. And there's no "Go to" action in matrix visual.

Regards,