Forum Discussion
Rearranging in columns in Table Matrix visual
How do I re arrainge these columns to be a specific order?
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.
4 Replies
FarhanAhmedCommunity Champion
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"
samdthompsonMemorable Member
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
- amitchandak
Super User
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
v-xicaiCommunity Support
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.
