Forum Discussion
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 the columns to be arranged as follows (currently they are sorted alphabetically)
2) I want the sub-apps, within apps to be sorted by the column "very frequently experienced".. here is the example
Please assist
Thanks
4 Replies
- amitchandak
Super User
talhaparvaiz , 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)
talhaparvaizHi, 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
- v-xulin-mstf
Community Support
Hi talhaparvaiz,
Matrix visuals can be sorted directly in the columns or using the 3 dots on the header, check if any of those possibilities work for you.
And here the related post, maybe it will work.
Best Regards,
Link
