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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
momodj20
Helper II
Helper II

Order By multiple columns

i have a report with a table, can i order a report for multiple columns in the view?

 

 

thanks

 

 

 

1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

Hi @momodj20 ,

 

We can create a calculated column to order it like following example,

 

Index = 
VAR p = [Power Level]
VAR n = [Name]
VAR a = [Age]
VAR t1 = 'Table3'
VAR t2 =
    FILTER ( 'Table3', 'Table3'[Power Level] = p )
VAR t3 =
    FILTER ( 'Table3', 'Table3'[Power Level] = p && 'Table3'[Age] = a )
RETURN
    RANKX (
        t1,
        RANKX ( t1, [Power Level],, ASC, SKIP ) * 100
            + RANKX ( t2, [Age],, ASC, SKIP ) * 10
            + RANKX ( t3, [Name],, ASC, SKIP ),
        ,
        DESC,
        SKIP
    )

This will sort by Power Level, then Age, and at last sort by name order. 

 

3.PNG

 

Then if you want to see the order in Data view, just sort by index column.

4.PNG5.PNG

 

If you want to see order in table visual, you can put the column into the table visual.

6.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lid-msft
Community Support
Community Support

Hi @momodj20 ,


How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lid-msft
Community Support
Community Support

Hi @momodj20 ,

 

We can create a calculated column to order it like following example,

 

Index = 
VAR p = [Power Level]
VAR n = [Name]
VAR a = [Age]
VAR t1 = 'Table3'
VAR t2 =
    FILTER ( 'Table3', 'Table3'[Power Level] = p )
VAR t3 =
    FILTER ( 'Table3', 'Table3'[Power Level] = p && 'Table3'[Age] = a )
RETURN
    RANKX (
        t1,
        RANKX ( t1, [Power Level],, ASC, SKIP ) * 100
            + RANKX ( t2, [Age],, ASC, SKIP ) * 10
            + RANKX ( t3, [Name],, ASC, SKIP ),
        ,
        DESC,
        SKIP
    )

This will sort by Power Level, then Age, and at last sort by name order. 

 

3.PNG

 

Then if you want to see the order in Data view, just sort by index column.

4.PNG5.PNG

 

If you want to see order in table visual, you can put the column into the table visual.

6.PNG

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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