How to rearrange attributes column in Matrix

[Anonymous]

Hi All,

I have a Matrix which only shows attributes of user selections with slicers. But do you guys know how to rearrange the attributes column according to my needs?

I would like to arrange in this sequence: Qty > ProdQty > Brazing > CONTROL BOX > WIRING DIAGRAM

But it seems that it will only arrange alphabetically and I am using a direct query for my table which I have unpivot the selection column, so adding an index column doesnt seem working. Please advise.

[amitchandak]

@Anonymous , I assuming these are values of a column (Used in column of Matrix)

Then you have create a sort column

Example

Sort Col =Switch(True() ,

[Col]= "Prod Qty", 1,

//Add other

6 //Default

)

and use that as the sort colum

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

Hi @amitchandak ,

Thank you for your reply. I have created an index column:

Index = SWITCH(True(),

Schedule_Profile[Attribute] = "Qty", "1",

Schedule_Profile[Attribute] = "ProdQty", "2",

Schedule_Profile[Attribute] = "Brazing", "3",

Schedule_Profile[Attribute] = "COIL", "4",

Schedule_Profile[Attribute] = "COMPRESSOR" , "5",

"6")

But when i sort attributes column by the new index column, it shows error:

Please advise. Thank you.

[Anonymous · Accepted solution]

Hi All,

Manage to solve this issue by creating a new table with attribute column and forming the relationship between the actual schedule_profile table and new sort table.

You may refer to more details here:

https://www.youtube.com/watch?v=4xapOrfLvbg

Thank you all.