Multiple Sub Title in Matrix Visual

[gaurav_analyst]

Essentially, I'm exploring how to incorporate multiple subheadings into a matrix visualization.

Here are the matrix settings I've applied so far:

1. Values serve as measures and have been pivoted into rows.

Output Sample:- 

[Anonymous · Accepted solution]

Hi @gaurav_analyst ,

Thanks for the reply from lbendlin .

For the row-level hierarchy, you can directly drag two fields to display them.

For the column level, you can refer to the following operations:

Here's the example data I created:

Test Type	Column1	Column2
111	1	18
222	2	17
333	3	16
444	4	15
555	5	14
666	6	13
777	7	12
888	8	11
999	9	10

Create a few simple measures:

A1 = AVERAGE('Table'[Column1])

A2 = COUNT('Table'[Column2])

B1 = SUM('Table'[Column1])

B2 = SUM('Table'[Column2])

Create a table:

Table 2 = CROSSJOIN(VALUES('Table'[Test Type]),{"Group A", "Group B"})

Create two measures that serve to group A1 and B1 into Group A and A2 and B2 into Group B.

Measure = 
SWITCH(
    TRUE(),
    MAX('Table 2'[Value])="Group A",CALCULATE([A1],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type]))),
    MAX('Table 2'[Value])="Group B",CALCULATE([A2],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type])))
)

Measure 2 = 
SWITCH(
    TRUE(),
    MAX('Table 2'[Value])="Group A",CALCULATE([B1],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type]))),
    MAX('Table 2'[Value])="Group B",CALCULATE([B2],FILTER('Table','Table'[Test Type]=MAX('Table 2'[Test Type])))
)

Using the matrix visual object for display, the final page visualization is shown below:

If you have any other questions please feel free to contact me.

The pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...