Sort Values from Calculated Column

Hi AkshayManke,

Sorting the "Due Status" column as per your expectations is possible. We can use the Sort By Column functionality in Power BI to achieve the desired sorting, though we need to keep in mind to avoid circular dependency while sorting. Please follow the steps below - 

• I am assuming you created the Due Status calculated column using some logic in DAX. Assume the following sample data I created

• We need to assign a number/ code to each due status which will be used for sorting the column. If you create a calculated column "Due Status Order" based on Due Status column itself, it will lead to circular dependency issues, as shown below - 

Due Status Order = 
SWITCH(
    Products[Due Status],
    "Overdue", 1,
    "Due Today", 2,
    "Not Due Today", 3
)

• Hence instead, create a calculated column with the exact same formula as your Due Status column, just replace the values "Overdue", "Due Today" and "Not Due Today" with 1, 2 and 3 respectively. This means we are just creating a calculated column for ordering statuses based on the source column itself. I will call this column as "Due Status Order Source"
• Select Due Status Column and click on Column Tools Tab -> Sort By Column -> Due Status Order Source

Voila! The columns in the matrix should now be sorted

Before Sorting:

After Sorting:

This behaviour is very well explained using the following diagrams available here

Let me know if you have any questions!

Hi AkshayManke;

You can add a new column to set an index for that column, using something like this:

Index = 
SWITCH( 
    TRUE(), 
    T_OutboundDelivery[DueStatus] ="Overdue", 1,
    T_OutboundDelivery[DueStatus] = "Due Today", 2,
    T_OutboundDelivery[DueStatus] ="Not Due Today",3
)

And after select the column where you have Overdue information and sort that column by the index column that you created, like this:

I had the same problem as AkshayManke ,

I solved it by doing this:

I made a conditional column, with the ranks I wanted.

So in this case, when Overdue = 1, Due Today = 2, Not Due Today = 3 (called ranks).

Then I made this ranks column a number type (I also made it a sum).

Then I sorted the table on the basis of the ranks column. This causes that the initally column also got sorted in the right way.

When I tried again in the matrix, I got the sequence I wanted.

Maybe this also helps for you.