Reorder order of columns in Matrix

[javif_84]

Hi guys

Might be basic sorry but not sure on how to proceed

This is a matrix, got all the years and then the facts... Is there a way so I can put first al the facts and then all the years available below... Think this is not possible but I want to be sure 

Thanks all!

[lbendlin · Accepted solution]

You cannot have measures as column headers.  To work around that limitation, create a reference table with the desired column names and their sort order, and then create a single measure that returns the result according to the selected category.

[Anonymous · Accepted solution]

Hi @javif_84 ,

As @lbendlin said, we cannot use measure in row/column parameter.

Could you please provide sample raw data and expected output?

Best Regards,

Wearsky

[javif_84]

Thanks, for the reply. No worries I´ll work around creating a Switch to put all measures in a data segmentation...

[lbendlin · Accepted solution]

You cannot have measures as column headers.  To work around that limitation, create a reference table with the desired column names and their sort order, and then create a single measure that returns the result according to the selected category.