Forum Discussion

mogugu_84's avatar
mogugu_84
Icon for Helper I rankHelper I
1 year ago
Solved

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    
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    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=Wqh9H3L2oLM

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

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=Wqh9H3L2oLM

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.