Matrix Sort by date descending cant get to work

[dancostin1990]

Hi Everyone, 

I have a matrix like the below which the dates are in columns, the dates come from a calendar table which has a day of year column and a index column and connected to my data , I have tried to use the index column as a sort by column and it doesnt change the way it is sorted, I want this to be sorted descending so the latest date is first

[v-yalanwu-msft · Accepted solution]

Hi, @dancostin1990 ;

First you could add index  column with the latest date of 1, then 2, and push back in order.

Then sort by index column.https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dancostin1990]

Thank You Very Much, This has worked

[KNP]

@dancostin1990 - I think this may help with your column sorting...

https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/

[littlemojopuppy]

Can you provide some sample data?  Drop your pbix into Google Cloud and provide a link to share it (after anonymizing anything sensitive)?

[littlemojopuppy]

Hi @dancostin1990 I'm assuming that hovering over the three dots on the top right of the matrix and checked the sort by?

[dancostin1990]

Yes tried that and unfortunately didn't sort or do anything 😕