Forum Discussion

mogugu_84's avatar
mogugu_84
Helper 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    
  • Ritaf1983's avatar
    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.