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!