Forum Discussion
dancostin1990
4 years agoRegular Visitor
Matrix Sort by date descending cant get to work
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 ha...
- 4 years ago
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.
KNP
Super User
4 years agodancostin1990 - I think this may help with your column sorting...
https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/