Trouble with Custom Sort

[BozPLR]

I am having trouble getting a custom sort to work. 

Following the great response here , I created a sort order table with my desired sort order for the statuses. 

I connected the sort table to the fact table via a relationship. 

I used the Status from the sort table in a visual, sorted by it, and it is still sorting alphabetically instead of the desired sort order. 

Could anyone advise me on how to troubleshoot why this is not working?

[v-hjannapu]

Hi @BozPLR,

I would also take a moment to thank @Ritaf1983 , @vojtechsima  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Coumminity Support Team.

[Ritaf1983]

Hi @BozPLR 

If the sort order is still not applied, it usually means the visual is using the Status column from the fact table instead of the one from your custom sort table.
The “Sort by Column” feature only works when both columns belong to the same table.

You can either duplicate the Status column inside the sort table and use it directly in your visuals, or merge the sort order column into your fact table.

You might also find this post helpful — it includes a working example and file:
https://community.fabric.microsoft.com/t5/Desktop/Need-to-break-out-a-matrix-outline-data-set-from-i...

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

[vojtechsima · Accepted solution]

Hey, @BozPLR ,

Silly question, but do you have the column "Status" in the sort table, sorted by column "Order"? Because I can see you have Order sorted by Orded, which is good, but you primarily need to sort the thing you will display by the numeric value.

[BozPLR]

No silly questions here! The way that you phrased me made sense to me. We are functional now. Thank you much!

[vojtechsima]

@BozPLR  love it.