Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Custom sorting in Power BI can significantly enhance the clarity and impact of your data visualizations. However, users often encounter several challenges when setting up custom sorts. Here’s a look at some of the common hurdles and how to overcome them:
Create a Custom Table with all the category either manually in Power Query or read from source.
Create a new column beside and provide the number in the order you want to arrange.
Create a relationship between the column in actual table to the custom sort table.
Create a column in Actual table with an expression.
Sort order = RELATED(CustomSortTable[Sort])
Select the column you want to sort, and a “Column Tools” menu bar will appear at the top. Now Select the “Sort by column” and select the sort order column.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.