Ordering Column values

[DevadathanK]

Hi Community!

<Message deleted>

Thanks in advance!

[amitchandak · Accepted solution]

@DevadathanK , You need to create sort column and then mark that as sort column of this column .

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

new columns

Aging1= Aging

Aging Sort =

Switch( True() ,
Aging=ing ="3-5", 1,
Aging= "6-9", 2,
Aging="10-15", 3,
// Add more conditions ,
4)

to avoid circular dependencies, create aging1 Sort that on Aging Sort and use Aging 1

[Pragati11 · Accepted solution]

Hi @DevadathanK ,

You will have to create a custom sort order for this column as their naming is not by-default in an order.

You can create an sortOrder column like this:

sortOrder = IF([Aging] = "0 to 2 Days", 1, IF([Aging] = "3 to 5 Days", 2, IF([Aging] = "6 to 9 Days", 3,  IF([Aging] = "10 to 15 Days", 4, 5)))) 

Now use this sortOrder column to sort your Aging column in the data by using SORT BY COLUMN in Data section.

Click on your Aging column under Data tab in Power BI and using Sort By Column as shown below: (Select sortOrder column under Sort By Column option)

Thanks,

Pragati

[negi007]

@DevadathanK  You will need create one more table where you will have two columns 

1. Sorting column (column on which sorting is required)

2. SI No

Once you create this table, then create relationship with your main table. Once realtionship is created then in your new table in Data tab you will get option to sort column by SI NO.

[amitchandak · Accepted solution]

@DevadathanK , You need to create sort column and then mark that as sort column of this column .

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

new columns

Aging1= Aging

Aging Sort =

Switch( True() ,
Aging=ing ="3-5", 1,
Aging= "6-9", 2,
Aging="10-15", 3,
// Add more conditions ,
4)

to avoid circular dependencies, create aging1 Sort that on Aging Sort and use Aging 1

[NiMa]

Thanks for this Solution @amitchandak . I followed the same steps but still im getting circular dependency after sorting Aging1 column on Aging Sort. How should i remove this? Please help.

[DevadathanK]

Hi @amitchandak 

Thank you for the insight! I got the circular dependency, thank you for letting me know the solution to it.