Waterfall - Custom Sorting in PowerBI?

Waterfall - Custom Sorting in PowerBI?



I'm aware of the sorting function in waterfall, but that seems to sort the items by category and y-axis column.



WaterFall Data



What I'm hoping to do is sort non- category or y-axis column.



Waterfall Power BI



Needs to be organize by the following order:



FY 17 YTD, Revenue , Transport , Services and Delivery, HQ, Dispatch, Duties , GL Admin



Thank you.




1 Answer
1



Add a column to your source data and populate it with values for the preferred sort order.



Then select the column you want to custom sort and click Modeling > Sort by Column. Select the new column as the SortBy column for the existing column. The SortCategory column is used as the sort order for the Category column.






@AlfMiolan For reference, here's documentation on Sort by Column

– Alexis Olson
Sep 10 '18 at 19:28



Thanks for contributing an answer to Stack Overflow!



But avoid



To learn more, see our tips on writing great answers.



Required, but never shown



Required, but never shown




By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.