Matrix Table Headers Order

Hey PatCreator ,

you can not achieve what you are looking for without using a little trick.

Create an unrelated table with two columns

Measure Name and Measure Order

Use the name of the measure/columns you are currently using in the Values bucket, and provide an index  to order the values of the name column accordingly.

Then you can create a measure like so:

switch measure=
var SelectedKPI = SELECTEDVALUE( 'unrelated table'[NameColumn] )
return
SWITCH(
SelectedKPI
, "name1" , [Measure1]
, "name2" , [Measure3]
, "name3" , [Measure3]
)

Maybe it is necessary that you create measures or internal calculations if the columns you are using in the values bucket are numeric columns and not measures

Hopefully, this provides an idea of how you can tackle your challenge.

Regards,

Tom