Rearranging in columns in Table Matrix visual

[Anonymous]

How do I re arrainge these columns to be a specific order? 

[v-xicai · Accepted solution]

Hi @Anonymous ,

Firstly, you may create a calculated table named 'SortTable' via button "Enter Data" under Home ribbon (assuming the sort order is like column [Order] below), then create relationship with your fact table with Both of Cross filter direction on related field.

Secondly, you may select on the status column of your fact table,  which contains values "In-Process", "Not Started" ,,etc,  go to Column tools ->Sort by column, choose the option 'SortTable'[Order].

For reference:

Sort by column in Power BI Desktop

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Create a new sort column in you table

Sort COlumn =

SWITCH (
TRUE(),
[Column] = "In progress", 1,
[Column] = "Completed", 2, // add other condition
3
)

Then set it has the sort column

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

[samdthompson]

Add a sort by column to the table using either SWITCH(). Then use the Sort by column on the column tools ribbon when the field is active.

// if this is an answer please mark as such

[FarhanAhmed]

If this is single column values you can use "Sort by Other Column" to sort data in specific order.

Create a new column in Power Query and give them numbers accordingly to your desired order

Then you need to apply "Sort by Other Column"

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column#:~:text=Select%20whi...