Forum Discussion
Matrix table column alphabetical order
I thought this should be easy, just want to sort the columns from P, L, then B, so basically alphabetically descending order, is there no easy way to do it? without customer sort? Thanks
Hi mogugu_84
You need to add a column for sorting with the needed order to the data table.
For example from PQ :After closing and applying from the table view modify the sort of the wanted category by this added sort column:
Result
PBIX is attached
More information about sorting by another column:
https://www.youtube.com/watch?v=Wqh9H3L2oLMIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
4 Replies
thank you, this works well. got the job done. but i really hope that they can come up with a button somewhere to just click and sort ascending/descending for such cases....
Happy to help, i hope so 2...:)
Hi mogugu_84
You need to add a column for sorting with the needed order to the data table.
For example from PQ :After closing and applying from the table view modify the sort of the wanted category by this added sort column:
Result
PBIX is attached
More information about sorting by another column:
https://www.youtube.com/watch?v=Wqh9H3L2oLMIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi mogugu_84
You would not be able to sort column in matrix visual as you do it for rows.
To sort column, you need to add a new column in your data model that represents the alphabetical order of your columns.Then select the column you want to sort, then go to the "Column Tools" tab and choose "Sort by Column". Select your new sort column, and you are done.
In matrix column will be automatically sorted according to your custom sorting.
Hope this helps!!If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
