Reordering Column Headers in Matrix with Field Parameters and Calculation Groups

Hello guys,

I created 2 separate measure field parameters (FP) for selecting categories of measures:

• FP1: total sales, total quantity, etc.
• FP2: total cost, training cost, etc.

I also created 2 calculation groups for time intelligence:

• CG1: current period, previous period, same period last year (SPLY) for time comparison
• CG2: month to date, year to date for time-based metrics

I added all 4 of them as separate slicers for my matrix. What I need is that when I select any field from 4 slicers, they should reflect in the matrix. For example, when I select total sales from FP1, total cost from FP2, current period and SPLY from CG1, and both items from CG2, my matrix will show like this:

Matrix with CG and FP

This matrix is good. However, I want to change the position of the column header. Currently, the column header appears as a hierarchy, with the measures at the lowest level and the 2 calculation groups above them.

Is there any way to show the measure at the first level, or the second level, or change it ourselves? Something like this:

Column Header 1

or

Column Header 2

Another way I tried:

Instead of creating calculation groups, I created all detailed measures such as Total sales MTD, Total cost MTD, Total sales YTD, Total cost YTD, Total sales MTD SPLY,  Total cost MTD SPLY, etc. Then I created a table All KPIs to list all detailed measure names and some corresponding columns needed:

All KPIs table

and a measure using SWITCH also is created:

Header Measure =

VAR MeasureName = SELECTEDVALUE('All KPIs'[Measure name])

RETURN

SWITCH(

TRUE(),

MeasureName = "Total Sales MTD", [Total Sales MTD],

MeasureName = "Total Sales MTD SPLY", [Total Sales MTD SPLY],

MeasureName = "Total Sales YTD", [Total Sales YTD],

MeasureName = "Total Sales YTD SPLY", [Total Sales YTD SPLY],

MeasureName = "Total Cost MTD", [Total Cost MTD],

MeasureName = "Total Cost MTD SPLY", [Total Cost MTD SPLY],

MeasureName = "Total Cost YTD", [Total Cost YTD],

MeasureName = "Total Cost YTD SPLY", [Total Cost YTD SPLY]

...

)

I added this measure, Measure group, Time comparison, and Time-based to the matrix, and now the matrix looks fine with the reordered column header levels

Matrix

However, the problem I face with this approach is that I cannot use two slicers for separate 'Measure group'. I can only use one slicer for the Measure Group to filter the measures that appear in the matrix. This does not meet my requirement of having two slicers for groups of measures and two slicers for time-based and time comparison.

So, is there any way to meet my requirements? I have tried both approaches but haven’t found a solution.

Appreciate your guidance. Thank you!