Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II


Hi All,

I have this syntax that creates a table, it works. How can I add a Order by. I want to Order by Alpha, and NumValue. Thanks


Department – Slicer =
SUMMARIZE ( 'JBSIS Probate Full Report', 'JBSIS Probate Courthouse Department'[DeptAbbreviation], 'JBSIS Probate Courthouse Department'[CourtDept],'JBSIS Probate Courthouse Department'[Alpha],'JBSIS Probate Courthouse Department'[NumValue]),
"Used", 1
Community Support
Community Support

HI @pfarahani,

AFAIK, power bi does not support sort by multiple columns. You can take a look at the following link to use ISONORAFTER to achieve multiple column sorting:

Sorting by multiple columns 


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User
Super User

@pfarahani I agree with @Calvin69. I will add that you could create an additional column in your ADDCOLUMUS function that simply concatenates Alpha and NumValue using the & operator. You can add this to visuals, turn off word wrap and shrink the column width in the visual to hide it in table or matrix visuals . Then you can sort by it in the visual and nobody knows it's there. 

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper III
Helper III

Hi @pfarahani ,


If your table has been created successfully why not use the standard "Order" functions within PBI?

  • If you are looking at your data using the data view then you can use
    • Calvin69_0-1630377038252.png


    • or Calvin69_1-1630377081636.png


  • If you are using visuals, hover on top of your visual then click on the ellipse
    • Calvin69_2-1630377185837.png


I hope this helps


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors