Alphanumeric Ordering Fix Including a Hierarchy

[jmccorkle]

We have a software that utilizes BI to report on its stored data.

There is a certain dashboard built that there is a hierarchy in place for how the data is displayed. Now the names of the headers for each hierarchy is what the entire dataset is ordered by. But these names are ordered alphanumerically which is causing an issue with the ordering.

For example: the headings are currently ordered B-1, B-10, and B-2. When they should be ordered B-1, B-2, B-10. This is included in a screenshot below. Is there a way to have BI reorder these without changing the hierarchy and keeping all of the data groups properly grouped together?

[lbendlin · Accepted solution]

Add a column to your data model that indicates the desired sort order and then sort your header column by that column.

Sort one column by another column in Power BI - Power BI | Microsoft Learn