Forum Discussion

henryco88's avatar
henryco88
Icon for Helper II rankHelper II
5 years ago

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? To...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
    henryco88
    Icon for Helper II rankHelper II
    5 years ago

    The connection mode is import