Order of Stacked Bar char

[jlworthi]

I have a single stacked bar chart of level of education. Currently Power Bi displays it across in alphabetical order (college, graduate school high school technical). I would like it ordered by logical progression (technical, high school, college, graduate). How do I sort the order of a stacked bar chart? 

[ibarrau · Accepted solution]

Hi. When you select the columns in formating tab you can select the order by of this column. If you don't have any other column to help this order you want, add a new one responding if technical, new column = 1 if high school new column=2.... Then order the school columns by the new column.

Regards,

P/D You can create a new table with column NroOrder|School -> 1|high school and the relate it with yours. Same procedure with order.

[v-yulgu-msft · Accepted solution]

Hi @jlworthi,

To add to what ibarrau suggested, you need to create the custom column in Query Editor mode, rather than creating a calculated column with DAX formula.

Here is a link describing with detailed steps for your reference: Sort by another column error

Regards,
Yuliana Gu

[ibarrau · Accepted solution]

Hi. When you select the columns in formating tab you can select the order by of this column. If you don't have any other column to help this order you want, add a new one responding if technical, new column = 1 if high school new column=2.... Then order the school columns by the new column.

Regards,

P/D You can create a new table with column NroOrder|School -> 1|high school and the relate it with yours. Same procedure with order.