How to sort a row in ascending order in a matrix visual

[emmabr]

I have a matrix with data in in a Power BI report and along the top row, there are numbers from 1 to 12, which represent the months of the year e.g. 1 is January, 2 is February etc. 

How do I sort these numbers into ascending order in the matrix? 

It currently looks like this and isn't in order (I'd like it to run from 1 to 12):

Thanks

[v-yinliw-msft · Accepted solution]

Hi @emmabr ,

You can refer this link to try this method:

Solved: Sort values in matrix values - Microsoft Power BI Community

Hope this helps you. 

Best Regards,

Community Support Team _Yinliw

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