Forum Discussion
Solved
Matrix: Sorting by columns
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? ...
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 , 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
