Forum Discussion

BozPLR's avatar
BozPLR
Frequent Visitor
9 months ago
Solved

Trouble with Custom Sort

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 t...
Need Help
  • vojtechsima's avatar
    vojtechsima
    9 months ago

    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.

     

     

Ritaf1983's avatar
Ritaf1983
Super User
9 months ago

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-its/m-p/4650060/highlight/true#M1390631

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