Forum Discussion
Sort matrix column header
Hi all,
First of all, my apology since I have seen the same question had been posted numerous times and all answers are leading to creating new index/sort column, however I cannot seem to replicate the result for whatever reasons.
Here I have a simple table with year and index columns and all I wanted to do is just to sort the year descending.
Help appreciated.
Hcze
4 Replies
Thank you so much! I was under impression that the sorting applied to the whole table but apparently not. I have to click on Year column and sort by Index rather than click on Index column and sort by Index.
The gif is a nice touch and shows small details which otherwise missed!
hcze , On Matrix column there is not sorting available. It means your default sorting will stay. And that is Ascending. The way to do is create a Year Desc Rank Like this
Assume you have Year column in date table
Year = Year([Date]) // Similar formula -- This is column you alredy have
Year1 = Year([Date]) // new column to avoid circular depndencies
Year Rank = Rankx(All(Date),[Year1],,Desc,Dense) // Desc sort
Mark Year Rank sort column of Year.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thanks for sharing… check out the links below. It provides a comprehensive guide on how to sort measures as columns
in a matrix visual.
https://insurancedatainsights.blog/2024/04/27/dax-topn-brokers-and-others/
