Multiple levels of headers in matrix table

[Anonymous]

Hi, all users!

I'm trying to create a Power BI matrix table that has to have 4 different levels of headers within a matrix table. It must look something like this:

The measures are all within the same table, but the desired hierarchy structure of the header is not, which made me build a new table with that info, a Table_Appendix:

Then, I crossed-joined this appendix table with the original dataset table, which I called a MidTable, but now the data is duplicated because it is a Cartesian product. This is my current solution:

I tried to filter the cross join with DAX filters, but I am not going anywhere with this solution. Am I missing something?

Thank you so much for your help in advance!

[v-yingjl]

Hi @Anonymous ,

Based on your description, not certain what is your expected output. You can consider sharing some sample data or a dummy file for further discussion.

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Yingjie Li

[Anonymous]

Hi, @v-yingjl 

Just sent you a private message.

Thanks!

[amitchandak]

@Anonymous , can you share some kind of screenshot

[Anonymous]

Just sent you a private message.

Thanks!