Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sorting a text/number column in matrix - not sorting correctly

Hi guys   I have a matrix visualisation with a text field that includes both numbers and text. I have tried soring it the 'normal' way where i go to the "..." in the visual and choose "Sort by" and...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

Excellent Anonymous . The Sort By Column feature can be super handy sometimes.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm facing the same issue where I was trying to sort the Matrix header by descending order and it is not working. From  the above example, I would like to sort the Matrix header in descending order. I tried to sort the  Year using Sort by column and is not working. Also sorted the Year column in Power BI Query editor, it is showing in the descending order in Power BI Query editor and also in data tab. But when I pull in the fields in the visual on the Matrix  header it is not sorting by descending. Any help please

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    You should create a new thread for this, and include more info. Ideally a PBIX file so we can see exactly what is going on. This thread has been marked as "solved" so no one not in this thread will see it to offer more help.