Solved: Sort Matrix

Anonymous · ‎11-08-2018

Hello,

I am trying to sort the product column in my matrix by my custom sort. I designated the columns by numbers to allow for sorting but for some reason it will not adjust in my visual. I also designatted my sort by column to be order. Please advise.

v-yulgu-msft · ‎11-09-2018

Hi @Anonymous,

Have you specify the [Order] field as the "Sort by" column for [Product]?

If you have done above setting while it still doesn't work, please click the three dots on Matrix, and choose sort by [Product] for a test.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yulgu-msft · ‎11-09-2018

Hi @Anonymous,

Have you specify the [Order] field as the "Sort by" column for [Product]?

If you have done above setting while it still doesn't work, please click the three dots on Matrix, and choose sort by [Product] for a test.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎11-09-2018

I got it working, Thank you!

v-yulgu-msft · ‎11-12-2018

Hi @Anonymous,

Glad to hear that. Would you please kindly mark the helpful reply as an answer so that it can benefit more users or sharing your solution that fixed this problem?

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

garythomann · ‎03-16-2020

The Matrix visual lacks custom sorting functionality and more. There are lots of ideas on the community site. Below are the front runners. Please vote these up!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-s...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-f...