Forum Discussion

ChenChristyYu's avatar
ChenChristyYu
Helper II
8 years ago
Solved

PowerBI Matrix Table

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's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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