Sort column dimension in matrix table

[henryco88]

Hi,

I have a matrix table in Power BI Desktop. I have in the columns the dimensions in this order: 

Other   Business    Consumer  Wholesale   Total

How I Can sort the columns in this order?

Total   Busines     Consumer     Wholesale     Other

[v-lionel-msft]

Hi @henryco88 ,

Unfortunately, it's impossible to change the display position of ‘Total’ in the current version(2.87.923.0 64-bit November 2020).

Please submit your idea .

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @henryco88 ,

What's your connection mode?

If you're use 'Direct Query' or 'Live Connection' mode, you can't use the 'Sort by column' feature.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[henryco88]

The connection mode is import

[amitchandak]

@henryco88 , You have to create a column with sort order and mark that as the sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

https://www.youtube.com/watch?v=BnB4xUNisSA

[henryco88]

HI @amitchandak thanks your answer. I tried to do what you say but the sort is not there.