Forum Discussion
Sort column dimension in matrix table
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
5 Replies
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
HI amitchandak thanks your answer. I tried to do what you say but the sort is not there.
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The connection mode is import
