Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
You just have to tell PowerBI to sort your year column by your index 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/
@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
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!