Forum Discussion
Matrix Column Head Order
Anonymous
We can do that with following steps. Assuming we have a table like below. We can add a reverse index.
Close and apply Query Editor, select the Type column and make it sort by column of Index.
Now the order of the column heads will follow the Index.
If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.
Best Regards,
Herbert
Anonymous Maybe this will help. Create an index column like this:
Ordercol = if('tablename'[region] = "AMERICAS", 1,
if('tablename'[region] = "EMEA", 2, 3)).
This order column then can be treated like an indicies. Now make sure that the column is a number so go to modeling and change the data type to whole number.
Then select the region field and and make sure it is highlighted in the field list. Next, go to modeling and then in the banner, look for 'Sort' and choose 'Sort by Column' and this time select Ordercol as your sort order. Please let me know if this doesn't work.
This results in a Circular Dependency.