Defining a Custom Sort In Power BI. Useful for Displaying Work Order Workflow Status Order

One of the more useful features of Power BI is the ability to set the sort order of a column based on another column's values.

A good example of this is if you have a bar chart showing a list of categories e.g. the work types. On the visual you have the option to sort ascending or descending but it my not be correct to display these in alphabetical order.

In this video I'll talk you through the steps of setting up a custom sort that allows you to define the sort order. This will allow you to display the list of categories in any order the choose. For example if you a list of work order status codes you might want to display them in the order that a work order would progress through the work management process flow

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Recent Posts


About the author 

Jason Davidson

Jason Davidson is the founder of EffectiveDashboards.com. He is a maintenance and reliability engineer who uses Power BI every day to create dashboards that help him and others make better decisions. In his spare time, he likes running and has recently got into photography. He also loves spending time hanging out and larking about with his two daughters.

FREE Power BI Quick Start Course

Learn how to build a Power BI dashboard in under 90 minutes.

>