Forum Discussion
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!!!!!!!!!!
- Anonymous8 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
- AnonymousNot 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