Matrix: Sorting by columns

[LillyLegenda]

Hi, I may have a simple question, but I just cannot get it to work.

I have a Matrix and I would like the user to be able to click on BB, DD or Inv to sort by the column.

How is this possible? 

Thank you 🙂

[Anonymous · Accepted solution]

@LillyLegenda 

 I think you cannot sort by column.

 
Instead you can create New Column like below:

BB = IF(Sheet1[OrderType] = "BB",Sheet1[Volume],0)
DD = IF(Sheet1[OrderType] = "DD",Sheet1[Volume],0)
INV = IF(Sheet1[OrderType] = "INV",Sheet1[Volume],0)

Once done add these Columns to the "Values" and removed Order Type from "Columns". This will enable the sorting option as per your requirement.

Please find screenshots below:

Thanks,

Sandeep

[LillyLegenda]

Thank you very much @Anonymous ! This is working fine. Maybe it is just me but I think it should be a normal feature in a matrix. 

[Anonymous]

Other way to resolve this is using inforiver premium visual which sorts any invdividual column. However its paid if you want to publish the file for users to view it.

Thanks,

[rjhartop]

This blog post provides a workaround without using multiple measures:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

[manikumar34]

@LillyLegenda , 

Choose sort by column and order by Asc or Desc from 3 dot menu on the visula (...)

Regards, 

Manikumar

[amitchandak]

@LillyLegenda , Order by will sort Ascending or based on sort column. Create a sort column and mark that as sort column  for order by https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

I disucssed this type of case in video - https://www.youtube.com/watch?v=KK1zu4MBb-c

[LillyLegenda]

Hi @amitchandak. Sorry this is not helping me. 

I only have the option to sort by Type or Volume.

[amitchandak]

@LillyLegenda , there is no option for column(pivot) to sort -here it is OrderType . It will sort Ascending or based on sort column

Say I want sort descending

new columns

Order Type 1 = [Order Type]

Order TypeSort =rankx(all(Table), [Order Type] )

Mark Order TypeSort  as sort column for Order Type 1 and use that in sorting

I disucssed this type of case in video - https://www.youtube.com/watch?v=KK1zu4MBb-c