PowerBI Matrix Table

[ChenChristyYu]

Hi Expert,

I am new to PowerBI. I am creating this Matrix table, and here is a screenshot.

I have 3 layers and 10 values in this table. A batch can drill down to a job and then down to a report. 

Is there a function through which I can choose what value to show in different layers?

For example, I want only 'Batch Description', '# of jobs', 'Checkregistry Created' shown in the first layer,

when I drill down a certain batch, I would like to see 'Job Sequence', '# of reports' only

when I drill down to the lowest level, report level, I would like to have 'Start Time', 'CheckInfoCompletion', 'LinesComoplete', and 'PrintFileComplete' shown.

How can I better frame this table?  ANY suggestion is appreciated.

Thanks a lot!!!!!!!!!!

[Anonymous · Accepted solution]

HI @ChenChristyYu,

I don't think it can be achieved, current power bi can't custom displayed drill down labels.

For your scenario, I'd like to suggest you create a custom hierarchy with specific tree structure, then drag it to column level. It may suitable for your requirement.

Regards,

Xiaoxin Sheng