Forum Discussion
SORT Order
Self teaching Power BI and can't quite seem to get the correct DAX to sort diameter sizing depicted as the column headers here. How can I get the matrix to sort the diameters from smallest to largest? Thanks in advance for your help!
Hi SRIKER,
Add a conditional column in Query Editor mode.
In data view mode, change the default sort by column to [Sort Order].
Result.
Best regards,
Yuliana Gu
4 Replies
- v-yulgu-msftMicrosoft Employee
Hi SRIKER,
Add a conditional column in Query Editor mode.
In data view mode, change the default sort by column to [Sort Order].
Result.
Best regards,
Yuliana Gu
- SRIKERRegular Visitor
Thank you v-yulgu-msft. This is exactly what need! Unfortunately my Premium version does not seem to have the Add Column tab no the Conditional Column button. Double checked my version and I'm up to date. Bummer!
- SRIKERRegular Visitor
Sorry! I'm a rookie over here. Found it!. Thanks again for your help!
- rocky09Solution Sage
Sample data please..