Ｍatrix with double header, and first header across multiple columns

[Chester]

Dear all,

for Martrix, is that possible to show double header? And first header can across multiple columns. The example is as below. Currently I use TextBox for F1 & F2. It's not proper cause it will not align with second header width if second header figure size change. Is any idea to improve it. Thanks a lot.

[Anonymous]

Yes, its possible..you can manage it in the dataset only. create a field that should be having top level information (first header) like F1,F2. then create matrix visual and drag this field on colomns option

[Chester]

hi, hmalluri,
Thanks for your reply. When I drag this field on columns option, it appears on first header. However, it will double show the column fields marked as red. How to prevent NOT showing irrelevant columns? In other words, only show the columns data belong to its category. Thanks a lot.

PS:  F1,F2 are different measure, their DAX are as below for example

F1 = CALCULATE(SUM('Transaction'[Qty]),'DimItemTypeTable'[ItemType]="F1")
F2 = CALCULATE(SUM('Transaction'[Qty]),'DimItemTypeTable'[ItemType]="F2")

[Anonymous]

Hi @Chester ,

If you are using "F1" and "F2" as Columns, you will only need a single measure for each calculation.

That is "F1" and "F2" as header, [this period], [last period]...etc as sub header, no more [f1 this period], [f1 last period] ...etc.

Sample data for your reference.

Best Regards,

Jay

[Chester]

hi, Jay,

Thanks for your reply. Understand I'll remove F1&F2 text in sub header. And sorry for my inappropriate question&sample. Actually in my raw data sorce Excel, F1&F2 are different columns figures, and I also setup measures F1 and F2 as below. In other words, ItemType b volomes no need to be calculated in for F1 and vice versa.

Is that possible to achieve my purpose? Thanks a lot.

F1 = CALCULATE(SUM('Transaction'[F1]),'DimItemTypeTable'[ItemType]="a")
F2 = CALCULATE(SUM('Transaction'[F2]),'DimItemTypeTable'[ItemType]="b")