Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
YavuzDuran
Helper III
Helper III

Custom Sorting for a Calculated Column

Hi all,

I have a slicer in which there is a calculated column value. 

I want to make a custom sort like:

Current

1 Dat PD

2 - 5 PD

6 - 15 PD

16 - 30 PD

31+ PD

 

but since this is a calculated column I could not do it on Power BI query editor since it is not there.

I tied adding a table and putting index and bringing that index near to this calculated column by LOOKUPVALUE, there occurs a circular dependency 

 

Any other way that can help me? 

 

 

Acct Standing = if(AllAccounts[Actual # Days Past Due]=0,"Current",
if(AllAccounts[Actual # Days Past Due]=1,"1 Day PD",
if(and(AllAccounts[Actual # Days Past Due]>1,AllAccounts[Actual # Days Past Due]<6),"2 - 5 PD",
if(and(AllAccounts[Actual # Days Past Due]>5,AllAccounts[Actual # Days Past Due]<16),"6 - 15 PD",
if(and(AllAccounts[Actual # Days Past Due]>15,AllAccounts[Actual # Days Past Due]<31),"16 - 30 PD",
if(AllAccounts[Actual # Days Past Due]>30,"31+ PD",""))))))

 

 

YavuzDuran_0-1634909447327.png

 

1 ACCEPTED SOLUTION
mwegener
Most Valuable Professional
Most Valuable Professional

Hi @YavuzDuran,

 

for this you should use the function: "Sort one column by another column"

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?WT.mc_id=DP-MVP-5004...

 

Acct Standing Index =
IF (
    AllAccounts[Actual # Days Past Due] = 0,
    0,
    IF (
        AllAccounts[Actual # Days Past Due] = 1,
        1,
        IF (
            AND (
                AllAccounts[Actual # Days Past Due] > 1,
                AllAccounts[Actual # Days Past Due] < 6
            ),
            2,
            IF (
                AND (
                    AllAccounts[Actual # Days Past Due] > 5,
                    AllAccounts[Actual # Days Past Due] < 16
                ),
                3,
                IF (
                    AND (
                        AllAccounts[Actual # Days Past Due] > 15,
                        AllAccounts[Actual # Days Past Due] < 31
                    ),
                    4,
                    IF ( AllAccounts[Actual # Days Past Due] > 30, 5, 99 )
                )
            )
        )
    )
)
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


View solution in original post

2 REPLIES 2
mwegener
Most Valuable Professional
Most Valuable Professional

Hi @YavuzDuran,

 

for this you should use the function: "Sort one column by another column"

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?WT.mc_id=DP-MVP-5004...

 

Acct Standing Index =
IF (
    AllAccounts[Actual # Days Past Due] = 0,
    0,
    IF (
        AllAccounts[Actual # Days Past Due] = 1,
        1,
        IF (
            AND (
                AllAccounts[Actual # Days Past Due] > 1,
                AllAccounts[Actual # Days Past Due] < 6
            ),
            2,
            IF (
                AND (
                    AllAccounts[Actual # Days Past Due] > 5,
                    AllAccounts[Actual # Days Past Due] < 16
                ),
                3,
                IF (
                    AND (
                        AllAccounts[Actual # Days Past Due] > 15,
                        AllAccounts[Actual # Days Past Due] < 31
                    ),
                    4,
                    IF ( AllAccounts[Actual # Days Past Due] > 30, 5, 99 )
                )
            )
        )
    )
)
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Perfect. Worked. Thank you. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.