Forum Discussion
talhaparvaiz
Helper I
Helper IPower BI Matrix - column and row sorting
Hi, I have a table that looks something like this Based on the dataset above, I have created a matrix, that looks something like this I have 2 requirements: 1) I want ...
amitchandak
Super User
Super Usertalhaparvaiz , In matrix, if you are using a Column(pivot) then you can sort on grand total of the value (on column) or on the row column. You will not be able to sort on individual values of column(pivot)
talhaparvaizHelper I
Helper IHi, if I got it right, I can't have any of my requirements.
Thanks
- amitchandak
talhaparvaiz , You can rearrange column by creating a sort column
I have explained that in details in this video: https://www.youtube.com/watch?v=KK1zu4MBb-c
You need to a column with sort order and mark that as a sort column https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column